How to enter numerical numbers in rows where value is same

[Ann]

I have 500 lines and would like to number each row, however some rows contain
the same information 2 or more times, so I need to keep the numbering in
sequence by repeating the same number where the rows contain the same
information.

[Biff]

Hi!

Try this:

Assume your data is in the range A1:A500.

In B1 enter 1.

Enter this formula in B2 and copy down to B500:

=IF(A2=A1,B1,B1+1)

Biff

"Ann" <Ann@discussions.microsoft.com> wrote in message
news:4937D04D-0D57-4AF7-8399-C2433E9D7156@microsoft.com...
>I have 500 lines and would like to number each row, however some rows
>contain
> the same information 2 or more times, so I need to keep the numbering in
> sequence by repeating the same number where the rows contain the same
> information.

[Ann]

Thank you very much but =IF(A2=A1,B1,B1+1) did not work for me. Any other
suggestions?
Thanks


"Biff" wrote:

> Hi!
>
> Try this:
>
> Assume your data is in the range A1:A500.
>
> In B1 enter 1.
>
> Enter this formula in B2 and copy down to B500:
>
> =IF(A2=A1,B1,B1+1)
>
> Biff
>
> "Ann" <Ann@discussions.microsoft.com> wrote in message
> news:4937D04D-0D57-4AF7-8399-C2433E9D7156@microsoft.com...
> >I have 500 lines and would like to number each row, however some rows
> >contain
> > the same information 2 or more times, so I need to keep the numbering in
> > sequence by repeating the same number where the rows contain the same
> > information.
>
>
>

[Biff]

Post an example of your data and what result you expect.

Biff

"Ann" <Ann@discussions.microsoft.com> wrote in message
news:399F5496-CD42-43F3-9E5C-F124F480A4CB@microsoft.com...
> Thank you very much but =IF(A2=A1,B1,B1+1) did not work for me. Any other
> suggestions?
> Thanks
>
>
> "Biff" wrote:
>
>> Hi!
>>
>> Try this:
>>
>> Assume your data is in the range A1:A500.
>>
>> In B1 enter 1.
>>
>> Enter this formula in B2 and copy down to B500:
>>
>> =IF(A2=A1,B1,B1+1)
>>
>> Biff
>>
>> "Ann" <Ann@discussions.microsoft.com> wrote in message
>> news:4937D04D-0D57-4AF7-8399-C2433E9D7156@microsoft.com...
>> >I have 500 lines and would like to number each row, however some rows
>> >contain
>> > the same information 2 or more times, so I need to keep the numbering
>> > in
>> > sequence by repeating the same number where the rows contain the same
>> > information.
>>
>>
>>

[Ann]

Here's an example: Below I have entered 3 parts , but I have a toal of 6 rows
because I want to enter #7 twice,#8 once and #9 is entered 3 times.
7 388018400
7 388018400
8 387844800
9 388018500
9 388018500
9 388018500


"Biff" wrote:

> Post an example of your data and what result you expect.
>
> Biff
>
> "Ann" <Ann@discussions.microsoft.com> wrote in message
> news:399F5496-CD42-43F3-9E5C-F124F480A4CB@microsoft.com...
> > Thank you very much but =IF(A2=A1,B1,B1+1) did not work for me. Any other
> > suggestions?
> > Thanks
> >
> >
> > "Biff" wrote:
> >
> >> Hi!
> >>
> >> Try this:
> >>
> >> Assume your data is in the range A1:A500.
> >>
> >> In B1 enter 1.
> >>
> >> Enter this formula in B2 and copy down to B500:
> >>
> >> =IF(A2=A1,B1,B1+1)
> >>
> >> Biff
> >>
> >> "Ann" <Ann@discussions.microsoft.com> wrote in message
> >> news:4937D04D-0D57-4AF7-8399-C2433E9D7156@microsoft.com...
> >> >I have 500 lines and would like to number each row, however some rows
> >> >contain
> >> > the same information 2 or more times, so I need to keep the numbering
> >> > in
> >> > sequence by repeating the same number where the rows contain the same
> >> > information.
> >>
> >>
> >>
>
>
>

[Biff]

Take a look at this screencap:

http://img39.imageshack.us/img39/5531/countrows9vn.jpg

Biff

"Ann" <Ann@discussions.microsoft.com> wrote in message
news:653C3245-9762-4DA1-80A4-D3BE3F71DCF7@microsoft.com...
> Here's an example: Below I have entered 3 parts , but I have a toal of 6
> rows
> because I want to enter #7 twice,#8 once and #9 is entered 3 times.
> 7 388018400
> 7 388018400
> 8 387844800
> 9 388018500
> 9 388018500
> 9 388018500
>
>
> "Biff" wrote:
>
>> Post an example of your data and what result you expect.
>>
>> Biff
>>
>> "Ann" <Ann@discussions.microsoft.com> wrote in message
>> news:399F5496-CD42-43F3-9E5C-F124F480A4CB@microsoft.com...
>> > Thank you very much but =IF(A2=A1,B1,B1+1) did not work for me. Any
>> > other
>> > suggestions?
>> > Thanks
>> >
>> >
>> > "Biff" wrote:
>> >
>> >> Hi!
>> >>
>> >> Try this:
>> >>
>> >> Assume your data is in the range A1:A500.
>> >>
>> >> In B1 enter 1.
>> >>
>> >> Enter this formula in B2 and copy down to B500:
>> >>
>> >> =IF(A2=A1,B1,B1+1)
>> >>
>> >> Biff
>> >>
>> >> "Ann" <Ann@discussions.microsoft.com> wrote in message
>> >> news:4937D04D-0D57-4AF7-8399-C2433E9D7156@microsoft.com...
>> >> >I have 500 lines and would like to number each row, however some rows
>> >> >contain
>> >> > the same information 2 or more times, so I need to keep the
>> >> > numbering
>> >> > in
>> >> > sequence by repeating the same number where the rows contain the
>> >> > same
>> >> > information.
>> >>
>> >>
>> >>
>>
>>
>>

[Ann]

Thank you again for your help but it did not work for me.

"Biff" wrote:

> Take a look at this screencap:
>
> http://img39.imageshack.us/img39/5531/countrows9vn.jpg
>
> Biff
>
> "Ann" <Ann@discussions.microsoft.com> wrote in message
> news:653C3245-9762-4DA1-80A4-D3BE3F71DCF7@microsoft.com...
> > Here's an example: Below I have entered 3 parts , but I have a toal of 6
> > rows
> > because I want to enter #7 twice,#8 once and #9 is entered 3 times.
> > 7 388018400
> > 7 388018400
> > 8 387844800
> > 9 388018500
> > 9 388018500
> > 9 388018500
> >
> >
> > "Biff" wrote:
> >
> >> Post an example of your data and what result you expect.
> >>
> >> Biff
> >>
> >> "Ann" <Ann@discussions.microsoft.com> wrote in message
> >> news:399F5496-CD42-43F3-9E5C-F124F480A4CB@microsoft.com...
> >> > Thank you very much but =IF(A2=A1,B1,B1+1) did not work for me. Any
> >> > other
> >> > suggestions?
> >> > Thanks
> >> >
> >> >
> >> > "Biff" wrote:
> >> >
> >> >> Hi!
> >> >>
> >> >> Try this:
> >> >>
> >> >> Assume your data is in the range A1:A500.
> >> >>
> >> >> In B1 enter 1.
> >> >>
> >> >> Enter this formula in B2 and copy down to B500:
> >> >>
> >> >> =IF(A2=A1,B1,B1+1)
> >> >>
> >> >> Biff
> >> >>
> >> >> "Ann" <Ann@discussions.microsoft.com> wrote in message
> >> >> news:4937D04D-0D57-4AF7-8399-C2433E9D7156@microsoft.com...
> >> >> >I have 500 lines and would like to number each row, however some rows
> >> >> >contain
> >> >> > the same information 2 or more times, so I need to keep the
> >> >> > numbering
> >> >> > in
> >> >> > sequence by repeating the same number where the rows contain the
> >> >> > same
> >> >> > information.
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>
>

[Biff]

Well, the only other thing I can suggest is that if you'd like me to take a
look at your file then I can see what's "going on".

If you want to do that just let me know how to contact you.

Biff

"Ann" <Ann@discussions.microsoft.com> wrote in message
news:56AC03BD-D2B0-4836-B564-78E45615F8C4@microsoft.com...
> Thank you again for your help but it did not work for me.
>
> "Biff" wrote:
>
>> Take a look at this screencap:
>>
>> http://img39.imageshack.us/img39/5531/countrows9vn.jpg
>>
>> Biff
>>
>> "Ann" <Ann@discussions.microsoft.com> wrote in message
>> news:653C3245-9762-4DA1-80A4-D3BE3F71DCF7@microsoft.com...
>> > Here's an example: Below I have entered 3 parts , but I have a toal of
>> > 6
>> > rows
>> > because I want to enter #7 twice,#8 once and #9 is entered 3 times.
>> > 7 388018400
>> > 7 388018400
>> > 8 387844800
>> > 9 388018500
>> > 9 388018500
>> > 9 388018500
>> >
>> >
>> > "Biff" wrote:
>> >
>> >> Post an example of your data and what result you expect.
>> >>
>> >> Biff
>> >>
>> >> "Ann" <Ann@discussions.microsoft.com> wrote in message
>> >> news:399F5496-CD42-43F3-9E5C-F124F480A4CB@microsoft.com...
>> >> > Thank you very much but =IF(A2=A1,B1,B1+1) did not work for me. Any
>> >> > other
>> >> > suggestions?
>> >> > Thanks
>> >> >
>> >> >
>> >> > "Biff" wrote:
>> >> >
>> >> >> Hi!
>> >> >>
>> >> >> Try this:
>> >> >>
>> >> >> Assume your data is in the range A1:A500.
>> >> >>
>> >> >> In B1 enter 1.
>> >> >>
>> >> >> Enter this formula in B2 and copy down to B500:
>> >> >>
>> >> >> =IF(A2=A1,B1,B1+1)
>> >> >>
>> >> >> Biff
>> >> >>
>> >> >> "Ann" <Ann@discussions.microsoft.com> wrote in message
>> >> >> news:4937D04D-0D57-4AF7-8399-C2433E9D7156@microsoft.com...
>> >> >> >I have 500 lines and would like to number each row, however some
>> >> >> >rows
>> >> >> >contain
>> >> >> > the same information 2 or more times, so I need to keep the
>> >> >> > numbering
>> >> >> > in
>> >> >> > sequence by repeating the same number where the rows contain the
>> >> >> > same
>> >> >> > information.
>> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>> >>
>>
>>
>>