Formula to Count number of cells in a column until a criteria (or value) is reached

[dadaddydude]

Hi all,
I am looking for a way to count the number of cells in a column until a specific value*(1+X%) is reached, then start the count again in a different cell.
In the mini sheet I've uploaded:

The formula should be placed in C2 and use array A3:A54 to count cells downwards until it encounters a value which is equal or higer than B3*(1+1%). The result on this cell with the furmula in this case would be 15 (counts from row A3 to A17 marked in red)
I would like to be able to drag the formula downards, so, for instance, once it reaches cell C30, it will do the same thing (only this time, the array will be A31:A54 which is covered by dragging the formula downards). In this case the result of the formula on cell C30 would be 1, since A31>B30*(1+1%)

Any ideas?

Thank you!

Example.xlsx
	A	B	C
1	1.24	0
2	1	1.116	15
3	1.01	0
4	1.02	0
5	1.05	0
6	1.07	0
7	1.08	0
8	1.08	0
9	1.06	0
10	1.05	0
11	1.02	0
12	1.02	0
13	1	0
14	0.93	0
15	0.86	0
16	0.86	0
17	1.13	0
18	1.18	0
19	1.18	0
20	1.19	0
21	1.19	0
22	1.17	0
23	1.19	0
24	1.25	0
25	1.26	0
26	1.23	0
27	1.24	0
28	1.21	0
29	1.19	0
30	1.16	1.044	1
31	1.19	0
32	1.21	0
33	1.2	0
34	1.19	0
35	1.18	0
36	1.2	0
37	1.18	0
38	1.17	0
39	1.12	0
40	1.13	0
41	1.08	0
42	1.05	0
43	1.02	0
44	1.04	0
45	1.02	0
46	1.04	0
47	1.02	0
48	1.02	0
49	1.02	0
50	1.1	0
51	1.09	0
52	1.03	0
53	1.04	0
54	1.06	0
Sheet1

 

[Fluff]

Hi & welcome to MrExcel.
How about

+Fluff 1.xlsm
	A	B	C
1	1.24	0
2	1	1.116	15
3	1.01	0
4	1.02	0
5	1.05	0
6	1.07	0
7	1.08	0
8	1.08	0
9	1.06	0
10	1.05	0
11	1.02	0
12	1.02	0
13	1	0
14	0.93	0
15	0.86	0
16	0.86	0
17	1.13	0
18	1.18	0
19	1.18	0
20	1.19	0
21	1.19	0
22	1.17	0
23	1.19	0
24	1.25	0
25	1.26	0
26	1.23	0
27	1.24	0
28	1.21	0
29	1.19	0
30	1.16	1.044	1
31	1.19	0
32	1.21	0
33	1.2	0
34	1.19	0
35	1.18	0
36	1.2	0
37	1.18	0
38	1.17	0
39	1.12	0
40	1.13	0
41	1.08	0
42	1.05	0
43	1.02	0
44	1.04	0
45	1.02	0
46	1.04	0
47	1.02	0
48	1.02	0
49	1.02	0
50	1.1	0
51	1.09	0
52	1.03	0
53	1.04	0
54	1.06	0
Master

Cell Formulas
Range	Formula
C2:C53	C2	=IF(B2>0,MATCH(1,--(B2*1.01<=A3:A$54),0),"")
C54	C54	=IF(B54>0,MATCH(1,--(B54*1.01<=A$54:A55),0),"")
Press CTRL+SHIFT+ENTER to enter array formulas.

 

[dadaddydude]

Like magic! Thank you so much Fluff, much appreciated!

 

[Fluff]

You're welcome & thanks for the feedback.