Autonumber

N

NG_Leeds

Does anyone know if it is possible to input an "auto number" in to
column where it will count the number of entries starting at 1 and the
increasing, so that any new entries either at the bottom or in th
middle of the existing alters the number accordingly?

Thank you very much for any assistanc
 
M

Myrna Larson

You can count the number of entries starting at, say, A2, with a formula like
this: =COUNTA(A2:A6000). Adjust references to quit.
 
Top