Autonumbering Formula for Columns
Thank you Darren, worked beautifully!
Eddie
-----Original Message-----
=IF(D8<"",COUNTA($D$7:D8)+10000,"")
Note: the offending dot is in your original formula - the following bit:
&"."
--
Darren
"NYDUDE" wrote in message
...
I am trying to format Column "A" to automatically issue numbers
starting from 10001 to infinity. I am using thsis formula:
=IF(D8<"",COUNTA($D$7:D8)&".","")
It is important that the numbers generated in Column "A" based on
the
contents of Column "D", so if there's no entry in "D", Column "A" will
be blank.
The problem I am having is that I can not start with 10001, I can
however start with 1.
Also, Excel is placing a dot after my numbers. I don't like dots!
Please
help.
Eddie
.
|