Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
sorting
I use excel to do a mailing list. I use the numbering along the side. When
I add or delete an entry, my numbers get messed up. You might end up with two 88 for example and have to go through and check it out. What am I doing wrong? -- Dea |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
sorting
If you have the numbers in ColA in cell A1 use the formula; which will always
keep the numbering in order even if you delete or add in between. =ROW() If you have headers in Row1 then in cell A2 = ROW()-1 (and copy that down) If this post helps click Yes --------------- Jacob Skaria "Dazey" wrote: I use excel to do a mailing list. I use the numbering along the side. When I add or delete an entry, my numbers get messed up. You might end up with two 88 for example and have to go through and check it out. What am I doing wrong? -- Dea |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sorting Values Without Sorting Formulas | Excel Discussion (Misc queries) | |||
Automatic sorting (giving max and min) based on custom sorting lis | Excel Worksheet Functions | |||
Sorting VLookup vs Sorting SumProduct | Excel Discussion (Misc queries) | |||
Sorting Help | Excel Discussion (Misc queries) | |||
Sorting: Sorting by the First Character | Excel Discussion (Misc queries) |