Thread: autonumber
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben
 
Posts: n/a
Default autonumber
Hardy

=IF(A2<"",ROW(B950),"")


Gord Dibben Excel MVP

On Thu, 24 Nov 2005 07:46:30 -0800, "Hardy"
wrote:

=IF(A2<"",ROW(B1),"")

Reply With QuoteReply With Quote