Hi Taco,

formula in col A1 : =IF(B1<"",ROW(B1),"")
and Fill Down

Regards,
Jean-Yves

"taco" wrote in message
...
sure the way is so easy, but i'm a beginner who do not enough time to try
and
solve.
problem is..

coloumn B contains names. coloumn A numbering the recorded names.
i would like to insert a formula for auto numbering.
for example if there is nothing in B7, A7 empty.
and if B8 is contains data A8 should be A6+1.

thanks in advance for your help.