![]() |
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 |
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 |
All times are GMT +1. The time now is 08:44 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com