autonum field

[Mark]

Hi,
Is it possible to add autonum field in Excel?
Just like in Access. or need some VBA code
to this. Where can I find this sample or article?
Thanks,
Mark

 

[Frank Kabel]

Hi Mark
a real unique autonumbring functionality is not available in Excel. you
may try the following formula approach to number entries (note: they
are NOT fixed attached to a record):
in A1 enter the following formula
=IF(B1<>"",1,"")

in A2 enter the formula
=IF(B2<>"",MAX($A$1:OFFSET($A2,-1,0))+1,"")
and copy this formula down for as many rows as you like

 

[Mark]

Thanks.

Hi Mark
a real unique autonumbring functionality is not available in Excel. you
may try the following formula approach to number entries (note: they
are NOT fixed attached to a record):
in A1 enter the following formula
=IF(B1<>"",1,"")

in A2 enter the formula
=IF(B2<>"",MAX($A$1:OFFSET($A2,-1,0))+1,"")
and copy this formula down for as many rows as you like