Is there a way to count how many times some number(zero in my case) occur before another number occurs in the same series in either minitab or ms excel(or any other statistical software)?
Eg: if I got 0 0 0 0 0 1 0 0 1 0 as the series I want to get the number of failures before the first success which is 5 because after 5 zeros 1(success) occurs.