AUTO NUMBER
Hi,
I know you probably don't want this, but if you enter 1 in cell A1 and 2 in
A2, then highlight both and double click the fill handle Excel will number
sequentially as far down at the data goes in column B.
If you want a formula and you data is solid, no blanks in column B until
there are no more entries, then you can use the formula
=IF(B1<"",ROW(A1),"")
Or if you are putting the formula in A1 then
=IF(B1<"",ROW(),"")
Copy these down as far as necessary.
if this helps, please click the Yes button
--
Thanks,
Shane Devenshire
"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
|