Hi Everyone,
I need help on excel formula that can count how many cell in between 0 to 2 number in sequential and reset again the count once reach to the cell contain 0 and start again to count once reach to cell contain number 2.
Also the formula will IGNORE the count when cell did not start with number 0 and end to number 2 or did not follow the sequential 0,1,2.
Currently i have thousand data like this and i need to calculate the cell manually. Really appreciate if anyone can help.??
I need help on excel formula that can count how many cell in between 0 to 2 number in sequential and reset again the count once reach to the cell contain 0 and start again to count once reach to cell contain number 2.
Also the formula will IGNORE the count when cell did not start with number 0 and end to number 2 or did not follow the sequential 0,1,2.
Currently i have thousand data like this and i need to calculate the cell manually. Really appreciate if anyone can help.??