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


--

_______________________
Naz,
London


"Lino" wrote:

how to autonumber a range of cells