Thread: autonum field
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Frank Kabel Frank Kabel is offline
external usenet poster
 
Posts: 3,885
Default autonum field

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

--
Regards
Frank Kabel
Frankfurt, Germany


Mark wrote:
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