First cell with a value of 0 after a certain row

[Hipsterpotamus]

I need to determine the range of values from Column A in my dataset where the corresponding values values in Column B are not equal to 0. Finding the the first value (in this example, 7) is easy enough, but the last value is giving me some issues. Anyone have any advice on how to solve this problem?

Thank you!

Book1.xlsx
	A	B	C	D	E
1	1	0		First	Last
2	2	0		7
3	3	0
4	4	0
5	5	0
6	6	0
7	7	1
8	8	5
9	9	7
10	10	10
11	11	5
12	12	6
13	13	0
14	14	0
15	15	0
16	16	0
17	17	0
18	18	0
19	19	0
20	20	0
Sheet4

Cell Formulas
Range	Formula
D2	D2	=INDEX(A1:A99998,MATCH(TRUE,INDEX(B:B>0,0),))

 

[Fluff]

You need to get rid of the wraprows, that's what's breaking it.