How to count until a certain value?

[CHeiring]

Hi

I have a spreadsheet in which I have a Column in which a "1" indicated the beginning of a section of time and "2" indicates the end of this section.

I would like to be able to from top to bottom to go through column A (see Image), and the count the number of rows between the first time a cell contain "1" until a cell contains "2" - number of rows will equal duration. It should then continue for every "1" and "2". The result = number of rows between each "1" and "2" pair should show in column B. In Column C I have shown how I would like the results to be presented.

Is this possible to do in Excel with formulas?

Many thanks in advance

Cheers

Christian

 

[CHeiring]

Both the formulae posted here will return numbers & not text.

Yes - I messed up. I have an if statement where I accidentally combined the formula to write 1 (as a number) if true but "" if false. When changing to "" to 0 (as a number) problem disappeared