autonumbering

N

Naz

What do you mean by auto nummber

You could do the following

a b
1 1 Enter 1 for the first cell
2 =max($A$1:A1)+1 then drag down
3 =max($A$1:A2)+1 it will produce this second formula
4
5

HTH
 
V

Vic Sowers

Lino said:
how to autonumber a range of cells
Click to expand...

Enter into the first two cells in the column:
1
2

Then select both cells and dreag the little square down as far as needed.

- Or -

Enter
1
into the fist cell in the column and
=<the cell with 1 in it>+1 (e.g. A1+1)

Then select the second cell and drag it down as far as needed.
 
Top