| 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 |
| 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) | |||
Threaded Mode
