software

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.

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

quot;Annquot; gt; wrote in message
...
gt;I have 500 lines and would like to number each row, however some rows
gt;contain
gt; the same information 2 or more times, so I need to keep the numbering in
gt; sequence by repeating the same number where the rows contain the same
gt; information.
Thank you very much but =IF(A2=A1,B1,B1 1) did not work for me. Any other
suggestions?
Thanksquot;Biffquot; wrote:

gt; Hi!
gt;
gt; Try this:
gt;
gt; Assume your data is in the range A1:A500.
gt;
gt; In B1 enter 1.
gt;
gt; Enter this formula in B2 and copy down to B500:
gt;
gt; =IF(A2=A1,B1,B1 1)
gt;
gt; Biff
gt;
gt; quot;Annquot; gt; wrote in message
gt; ...
gt; gt;I have 500 lines and would like to number each row, however some rows
gt; gt;contain
gt; gt; the same information 2 or more times, so I need to keep the numbering in
gt; gt; sequence by repeating the same number where the rows contain the same
gt; gt; information.
gt;
gt;
gt;

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

Biff

quot;Annquot; gt; wrote in message
...
gt; Thank you very much but =IF(A2=A1,B1,B1 1) did not work for me. Any other
gt; suggestions?
gt; Thanks
gt;
gt;
gt; quot;Biffquot; wrote:
gt;
gt;gt; Hi!
gt;gt;
gt;gt; Try this:
gt;gt;
gt;gt; Assume your data is in the range A1:A500.
gt;gt;
gt;gt; In B1 enter 1.
gt;gt;
gt;gt; Enter this formula in B2 and copy down to B500:
gt;gt;
gt;gt; =IF(A2=A1,B1,B1 1)
gt;gt;
gt;gt; Biff
gt;gt;
gt;gt; quot;Annquot; gt; wrote in message
gt;gt; ...
gt;gt; gt;I have 500 lines and would like to number each row, however some rows
gt;gt; gt;contain
gt;gt; gt; the same information 2 or more times, so I need to keep the numbering
gt;gt; gt; in
gt;gt; gt; sequence by repeating the same number where the rows contain the same
gt;gt; gt; information.
gt;gt;
gt;gt;
gt;gt;
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.
7388018400
7388018400
8387844800
9388018500
9388018500
9388018500quot;Biffquot; wrote:

gt; Post an example of your data and what result you expect.
gt;
gt; Biff
gt;
gt; quot;Annquot; gt; wrote in message
gt; ...
gt; gt; Thank you very much but =IF(A2=A1,B1,B1 1) did not work for me. Any other
gt; gt; suggestions?
gt; gt; Thanks
gt; gt;
gt; gt;
gt; gt; quot;Biffquot; wrote:
gt; gt;
gt; gt;gt; Hi!
gt; gt;gt;
gt; gt;gt; Try this:
gt; gt;gt;
gt; gt;gt; Assume your data is in the range A1:A500.
gt; gt;gt;
gt; gt;gt; In B1 enter 1.
gt; gt;gt;
gt; gt;gt; Enter this formula in B2 and copy down to B500:
gt; gt;gt;
gt; gt;gt; =IF(A2=A1,B1,B1 1)
gt; gt;gt;
gt; gt;gt; Biff
gt; gt;gt;
gt; gt;gt; quot;Annquot; gt; wrote in message
gt; gt;gt; ...
gt; gt;gt; gt;I have 500 lines and would like to number each row, however some rows
gt; gt;gt; gt;contain
gt; gt;gt; gt; the same information 2 or more times, so I need to keep the numbering
gt; gt;gt; gt; in
gt; gt;gt; gt; sequence by repeating the same number where the rows contain the same
gt; gt;gt; gt; information.
gt; gt;gt;
gt; gt;gt;
gt; gt;gt;
gt;
gt;
gt;

Take a look at this screencap:

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

Biff

quot;Annquot; gt; wrote in message
...
gt; Here's an example: Below I have entered 3 parts , but I have a toal of 6
gt; rows
gt; because I want to enter #7 twice,#8 once and #9 is entered 3 times.
gt; 7 388018400
gt; 7 388018400
gt; 8 387844800
gt; 9 388018500
gt; 9 388018500
gt; 9 388018500
gt;
gt;
gt; quot;Biffquot; wrote:
gt;
gt;gt; Post an example of your data and what result you expect.
gt;gt;
gt;gt; Biff
gt;gt;
gt;gt; quot;Annquot; gt; wrote in message
gt;gt; ...
gt;gt; gt; Thank you very much but =IF(A2=A1,B1,B1 1) did not work for me. Any
gt;gt; gt; other
gt;gt; gt; suggestions?
gt;gt; gt; Thanks
gt;gt; gt;
gt;gt; gt;
gt;gt; gt; quot;Biffquot; wrote:
gt;gt; gt;
gt;gt; gt;gt; Hi!
gt;gt; gt;gt;
gt;gt; gt;gt; Try this:
gt;gt; gt;gt;
gt;gt; gt;gt; Assume your data is in the range A1:A500.
gt;gt; gt;gt;
gt;gt; gt;gt; In B1 enter 1.
gt;gt; gt;gt;
gt;gt; gt;gt; Enter this formula in B2 and copy down to B500:
gt;gt; gt;gt;
gt;gt; gt;gt; =IF(A2=A1,B1,B1 1)
gt;gt; gt;gt;
gt;gt; gt;gt; Biff
gt;gt; gt;gt;
gt;gt; gt;gt; quot;Annquot; gt; wrote in message
gt;gt; gt;gt; ...
gt;gt; gt;gt; gt;I have 500 lines and would like to number each row, however some rows
gt;gt; gt;gt; gt;contain
gt;gt; gt;gt; gt; the same information 2 or more times, so I need to keep the
gt;gt; gt;gt; gt; numbering
gt;gt; gt;gt; gt; in
gt;gt; gt;gt; gt; sequence by repeating the same number where the rows contain the
gt;gt; gt;gt; gt; same
gt;gt; gt;gt; gt; information.
gt;gt; gt;gt;
gt;gt; gt;gt;
gt;gt; gt;gt;
gt;gt;
gt;gt;
gt;gt;
Thank you again for your help but it did not work for me.

quot;Biffquot; wrote:

gt; Take a look at this screencap:
gt;
gt; img39.imageshack.us/img39/5531/countrows9vn.jpg
gt;
gt; Biff
gt;
gt; quot;Annquot; gt; wrote in message
gt; ...
gt; gt; Here's an example: Below I have entered 3 parts , but I have a toal of 6
gt; gt; rows
gt; gt; because I want to enter #7 twice,#8 once and #9 is entered 3 times.
gt; gt; 7 388018400
gt; gt; 7 388018400
gt; gt; 8 387844800
gt; gt; 9 388018500
gt; gt; 9 388018500
gt; gt; 9 388018500
gt; gt;
gt; gt;
gt; gt; quot;Biffquot; wrote:
gt; gt;
gt; gt;gt; Post an example of your data and what result you expect.
gt; gt;gt;
gt; gt;gt; Biff
gt; gt;gt;
gt; gt;gt; quot;Annquot; gt; wrote in message
gt; gt;gt; ...
gt; gt;gt; gt; Thank you very much but =IF(A2=A1,B1,B1 1) did not work for me. Any
gt; gt;gt; gt; other
gt; gt;gt; gt; suggestions?
gt; gt;gt; gt; Thanks
gt; gt;gt; gt;
gt; gt;gt; gt;
gt; gt;gt; gt; quot;Biffquot; wrote:
gt; gt;gt; gt;
gt; gt;gt; gt;gt; Hi!
gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt; Try this:
gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt; Assume your data is in the range A1:A500.
gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt; In B1 enter 1.
gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt; Enter this formula in B2 and copy down to B500:
gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt; =IF(A2=A1,B1,B1 1)
gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt; Biff
gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt; quot;Annquot; gt; wrote in message
gt; gt;gt; gt;gt; ...
gt; gt;gt; gt;gt; gt;I have 500 lines and would like to number each row, however some rows
gt; gt;gt; gt;gt; gt;contain
gt; gt;gt; gt;gt; gt; the same information 2 or more times, so I need to keep the
gt; gt;gt; gt;gt; gt; numbering
gt; gt;gt; gt;gt; gt; in
gt; gt;gt; gt;gt; gt; sequence by repeating the same number where the rows contain the
gt; gt;gt; gt;gt; gt; same
gt; gt;gt; gt;gt; gt; information.
gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt;
gt; gt;gt;
gt; gt;gt;
gt; gt;gt;
gt;
gt;
gt;

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 quot;going onquot;.

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

Biff

quot;Annquot; gt; wrote in message
...
gt; Thank you again for your help but it did not work for me.
gt;
gt; quot;Biffquot; wrote:
gt;
gt;gt; Take a look at this screencap:
gt;gt;
gt;gt; img39.imageshack.us/img39/5531/countrows9vn.jpg
gt;gt;
gt;gt; Biff
gt;gt;
gt;gt; quot;Annquot; gt; wrote in message
gt;gt; ...
gt;gt; gt; Here's an example: Below I have entered 3 parts , but I have a toal of
gt;gt; gt; 6
gt;gt; gt; rows
gt;gt; gt; because I want to enter #7 twice,#8 once and #9 is entered 3 times.
gt;gt; gt; 7 388018400
gt;gt; gt; 7 388018400
gt;gt; gt; 8 387844800
gt;gt; gt; 9 388018500
gt;gt; gt; 9 388018500
gt;gt; gt; 9 388018500
gt;gt; gt;
gt;gt; gt;
gt;gt; gt; quot;Biffquot; wrote:
gt;gt; gt;
gt;gt; gt;gt; Post an example of your data and what result you expect.
gt;gt; gt;gt;
gt;gt; gt;gt; Biff
gt;gt; gt;gt;
gt;gt; gt;gt; quot;Annquot; gt; wrote in message
gt;gt; gt;gt; ...
gt;gt; gt;gt; gt; Thank you very much but =IF(A2=A1,B1,B1 1) did not work for me. Any
gt;gt; gt;gt; gt; other
gt;gt; gt;gt; gt; suggestions?
gt;gt; gt;gt; gt; Thanks
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt; quot;Biffquot; wrote:
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt;gt; Hi!
gt;gt; gt;gt; gt;gt;
gt;gt; gt;gt; gt;gt; Try this:
gt;gt; gt;gt; gt;gt;
gt;gt; gt;gt; gt;gt; Assume your data is in the range A1:A500.
gt;gt; gt;gt; gt;gt;
gt;gt; gt;gt; gt;gt; In B1 enter 1.
gt;gt; gt;gt; gt;gt;
gt;gt; gt;gt; gt;gt; Enter this formula in B2 and copy down to B500:
gt;gt; gt;gt; gt;gt;
gt;gt; gt;gt; gt;gt; =IF(A2=A1,B1,B1 1)
gt;gt; gt;gt; gt;gt;
gt;gt; gt;gt; gt;gt; Biff
gt;gt; gt;gt; gt;gt;
gt;gt; gt;gt; gt;gt; quot;Annquot; gt; wrote in message
gt;gt; gt;gt; gt;gt; ...
gt;gt; gt;gt; gt;gt; gt;I have 500 lines and would like to number each row, however some
gt;gt; gt;gt; gt;gt; gt;rows
gt;gt; gt;gt; gt;gt; gt;contain
gt;gt; gt;gt; gt;gt; gt; the same information 2 or more times, so I need to keep the
gt;gt; gt;gt; gt;gt; gt; numbering
gt;gt; gt;gt; gt;gt; gt; in
gt;gt; gt;gt; gt;gt; gt; sequence by repeating the same number where the rows contain the
gt;gt; gt;gt; gt;gt; gt; same
gt;gt; gt;gt; gt;gt; gt; information.
gt;gt; gt;gt; gt;gt;
gt;gt; gt;gt; gt;gt;
gt;gt; gt;gt; gt;gt;
gt;gt; gt;gt;
gt;gt; gt;gt;
gt;gt; gt;gt;
gt;gt;
gt;gt;
gt;gt;