Not sure what function will allow me to pull the correct period! Please Help!!

[Jarodjp42]

I am completely lost and I am not sure what function or formula will pull the correct period if the data changes. Can you please help.

What period do we start to see revenue?

Period	Revenue
1	0
2	0
3	0
4	0
5	0
6	10
7	10
8	25
9	30
10	50

<tbody>
</tbody>

What formula would be able to pull the correct period if the data updates?

 

[jim may]

Excel 2010

	A	B	C	D	E	F	G	H
1	Period	Revenue
2	1	0			What period do we start to see revenue?
3	2	0
4	3	0
5	4	0			Period
6	5	0			6
7	6	10
8	7	10
9	8	25
10	9	30
11	10	50

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Sheet1​

Array Formulas Cell Formula E6 {=INDEX(A2:A11,MIN(IF(B2:B11>0,ROW(B2:B11))))-1} <thead> </thead><tbody> </tbody> Entered with Ctrl+Shift+Enter. If entered correctly, Excel will surround with curly braces {}. Note: Do not try and enter the {} manually yourself

<tbody>
</tbody>

 

[Scott Huish]

=INDEX(A2:A11,MATCH(TRUE,B2:B11>0,0))
Confirm with CTRL-SHIFT-ENTER rather than just Enter.

Excel 2010
	A	B	C	D
1	Period	Revenue
2	1	0		6
3	2	0
4	3	0
5	4	0
6	5	0
7	6	10
8	7	10
9	8	25
10	9	30
11	10	50
Sheet1

Cell Formulas
Range	Formula
D2	{=INDEX(A2:A11,MATCH(TRUE,B2:B11>0,0))}
Press CTRL+SHIFT+ENTER to enter array formulas.