Hi,

I have 6000 id numbers in column A and I have had to delete some rows
due to duplication.

This now means those numbers which were in order 1 to 6000 now have
numbers missing.

How can I patch them up so that they are once again flowing from 1 to
whatever.

Thanks


rock

See other post.

--
__________________________________
HTH

Bob

"rock" wrote in message
...
Hi,

I have 6000 id numbers in column A and I have had to delete some rows due
to duplication.

This now means those numbers which were in order 1 to 6000 now have
numbers missing.

How can I patch them up so that they are once again flowing from 1 to
whatever.

Thanks


rock

Hi Bob,

I got the duplicate help thank you however this was a different thing..

------
I have 6000 id numbers in column A and I have had to delete some rows.


This now means those numbers which were in order 1 to 6000 now have
numbers missing.

eg

3458
3459
3460

3464
3465
3466

3469
3470
etc..

How can I patch them up so that they are once again flowing from 1 to
the last of them.

If I just delete the row, the numbers will stay missed whereas I want
them to be in order.

Thanks again


rock



Bob Phillips wrote:
See other post.

Several ways
1. a macro to put them in order
2. =row(a1) in the top rowcopied down

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"rock" wrote in message
...
Hi Bob,

I got the duplicate help thank you however this was a different thing..

------
I have 6000 id numbers in column A and I have had to delete some rows.


This now means those numbers which were in order 1 to 6000 now have
numbers missing.

eg

3458
3459
3460

3464
3465
3466

3469
3470
etc..

How can I patch them up so that they are once again flowing from 1 to
the last of them.

If I just delete the row, the numbers will stay missed whereas I want them
to be in order.

Thanks again


rock



Bob Phillips wrote:
See other post.

In A1 enter =ROW()

Copy down to end of data, overwriting the misplaced numbers with new
consecutive ones.


Gord Dibben MS Excel MVP

On Fri, 21 Aug 2009 20:28:49 +1000, rock wrote:

Hi Bob,

I got the duplicate help thank you however this was a different thing..

------
I have 6000 id numbers in column A and I have had to delete some rows.


This now means those numbers which were in order 1 to 6000 now have
numbers missing.

eg

3458
3459
3460

3464
3465
3466

3469
3470
etc..

How can I patch them up so that they are once again flowing from 1 to
the last of them.

If I just delete the row, the numbers will stay missed whereas I want
them to be in order.

Thanks again


rock



Bob Phillips wrote:
See other post.