| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
counting starting with a number other than 1
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| FORMULA for COUNTING #S STARTING WITH A 4 IN A RANGE 1 TO 100,000 | Excel Worksheet Functions | |||
| Count number of uniques starting with a given letter? | Excel Discussion (Misc queries) | |||
| Counting Starting Digits | Excel Worksheet Functions | |||
| Find Replace Number Starting with 0 | Excel Discussion (Misc queries) | |||
| How do you keep a 3-digit number starting with a "0" (ie. 058) | Excel Discussion (Misc queries) | |||
Linear Mode
