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" wrote in message
...
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" wrote in message
...
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" wrote in message
...
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" wrote in message
...
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.