I have a column of 1000+ numbers, but I want to be able to count the number of rows between each entry containing the value 1, e.g.
1 <--
15
25
3
5
2
1 <--
22
14
15
1 <--
How do I count those rows automatically please? Can anyone help?
1 <--
15
25
3
5
2
1 <--
22
14
15
1 <--
How do I count those rows automatically please? Can anyone help?