I have a column where i have a number of 0's that appear and 1's
looks like this
0
0
0
1
0
1
0
1
1
0
0
I need to count how many 0's occur before each 1.
Anyone know a formula?!?
Basically each 0 represents a unit of time, each 1 reprsents a lifetime..
by the end of this formula the lifetime should reset back to one and not 1,2,3,4,5,6
Bookmarks