Thread: AUTO NUMBER
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default AUTO NUMBER

Hi,

This isn't clear but how about this. Put a 1 in A1 and then this in A2 and
drag down

=IF(B2<"",MAX($A$1:A1)+1,"")

Also please switch of the CAPS, it's considered to shouting and makes things
difficult to read.

Mike

"ISIDOROS KMS" wrote:

I NEED A FUNCTION , MACRO TO NUMBERV AUTOMATICALLY IN COLUMN "A" THE THINGS I WRITE IN COLUMN "B"

THANK YOU IN ADVANCE