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