ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   sorting (https://www.excelbanter.com/excel-discussion-misc-queries/235119-sorting.html)

Dazey

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

Jacob Skaria

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