Show Starting (Number 1) and Max only

[ibmy]

Hi,

How get the result in column B?

Appreaciate all your help.

Book1
	A	B
1	Data	Result
2
3	1	1
4	0
5	0
6	1	1
7	1
8	1
9	1	4
10	0
11	1	1
12	1	2
13	0
Sheet1

 

[jasonb75]

I'm only taking 1 guess, if it's not right then you will need to explain what you want clearly.

Book5
	A	B
1	Data	Result
2
3	1	1
4	0
5	0
6	1	1
7	1
8	1
9	1	4
10	0
11	1	1
12	1	2
13	0
Sheet10

Cell Formulas
Range	Formula
B3:B13	B3	=IF(AND(A2=0,A3<>0),A3,IF(AND(A4=0,A3<>0),ROW(B3)-IFERROR(MATCH(1E+100,B$2:B2),0),""))