counting starting with a number other than 1
Instead of +1 as you've shown here, do +2001.
=IF('Sheet !'!A1 = 0,COUNT($A$6:A6)+1, " ")
becomes
=IF('Sheet !'!A1 = 0,COUNT($A$6:A6)+2001, " ")
--
Please remember to indicate when the post is answered so others can benefit
from it later.
"norman mellow" wrote:
I am creating automatically generated tracking numbers for groups of data by
using the following formula: =IF('Sheet !'!A1 = 0,COUNT($A$6:A6)+1, " ") ( in
these groups of data the header row is 0 in the A column, if that ake sense).
What I need to do now is make the count start at a number other than 1, say,
2000. What do I need to add to the forumla to accomplish that?
|