| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
count cells, then reset count when value in another cell changes
I am trying to create a function that will assign number for TaskID. It will
restart a count everytime there is a '0' in the Step column. This will be used for a database to group taskID and task separate. IF(a2 = 0, (0+1) < this does not work. Do you know how to do this? Step TaskID 0 1 1 1 2 1 0 2 1 2 2 2 3 2 4 2 0 3 1 3 2 3 3 3 4 3 5 3 -- Misty :-) Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...tions/200902/1 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
count cells, then reset count when value in another cell changes
One way...
Assuming the first entry is *always* 0. Enter 1 in B2 Enter this formula in B3 and copy down as needed: =IF(A3=0,B2+1,B2) -- Biff Microsoft Excel MVP "Mitchell_Collen via OfficeKB.com" <u33726@uwe wrote in message news:91f7b91409b5c@uwe... I am trying to create a function that will assign number for TaskID. It will restart a count everytime there is a '0' in the Step column. This will be used for a database to group taskID and task separate. IF(a2 = 0, (0+1) < this does not work. Do you know how to do this? Step TaskID 0 1 1 1 2 1 0 2 1 2 2 2 3 2 4 2 0 3 1 3 2 3 3 3 4 3 5 3 -- Misty :-) Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...tions/200902/1 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
count cells, then reset count when value in another cell changes
Try this:
=COUNTIF($A$2:A2,0) copy down "Mitchell_Collen via OfficeKB.com" wrote: I am trying to create a function that will assign number for TaskID. It will restart a count everytime there is a '0' in the Step column. This will be used for a database to group taskID and task separate. IF(a2 = 0, (0+1) < this does not work. Do you know how to do this? Step TaskID 0 1 1 1 2 1 0 2 1 2 2 2 3 2 4 2 0 3 1 3 2 3 3 3 4 3 5 3 -- Misty :-) Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...tions/200902/1 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
count cells, then reset count when value in another cell changes
Thanks!
-- Misty :-) Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...tions/200902/1 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
count cells, then reset count when value in another cell chang
You're Welcome!
"Mitchell_Collen via OfficeKB.com" wrote: Thanks! -- Misty :-) Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...tions/200902/1 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count the letters in the cells and sum in another cell | Excel Worksheet Functions | |||
| Reset sheet count | Excel Discussion (Misc queries) | |||
| can i use the color of a cell to count the different colerd cells | Excel Discussion (Misc queries) | |||
| Get first character in cell and count all cells that begin with 1,2,3 etc | Excel Discussion (Misc queries) | |||
| count non empty cells if other cell has certain value | Excel Discussion (Misc queries) | |||
Linear Mode
