sorting

D

Dazey

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?
 
J

Jacob Skaria

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
 
Top