AUTO NUMBER
I think your interpretation of what the OP wants (number only the cells that
are filled in) is probably correct; however, your method requires that the
first item in Column B must be located on Row 1. The following formula put
in A1 and copied down does not have that requirement...
=IF(AND(B1<"",COUNTA(B$1:B1)0),COUNTA(B$1:B1),"" )
--
Rick (MVP - Excel)
"Mike H" wrote in message
...
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
|