|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
August 21st, 2009, 08:08 AM
posted to microsoft.public.excel.newusers
|
|||
|
|||
ID inquiry about numbers in column A
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 
|
|
#2
August 21st, 2009, 09:10 AM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
ID inquiry about numbers in column A
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
|
|
#3
August 21st, 2009, 11:28 AM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
ID inquiry about numbers in column A
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.
|
|
#4
August 21st, 2009, 08:44 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
ID inquiry about numbers in column A
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.
|
|
#5
August 21st, 2009, 08:52 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
ID inquiry about numbers in column A
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.
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
