Start Count from first row of value appear to up

[ibmy]

Hi,

Sample data :

2.1.xlsb
	D	E	F	G	H	I	J	K	L
1	A	B			A				Count in B
2	7.6	1.22			1.3				1
3	8.9	1.3			1.39				0
4	1	1.7			1.7				3
5	1.3	1.22			1.22				4
6	1	2			1.9				0
7	1.39	1.3
8	4.2	1.3
9	1.3	1.3
10	4.2	1.7
11	1.3	1.7
12	1.7	1.22
13	1.3	1.7
14	1.7	1.22
15	1.22	1.3
16	1.22	2
17	1.9	1.22
18	1.9	2
sample

Explanation:

H2 value is 1.3 . Find value 1.3 in column D. Value 1.3 appear in D5, D9, D11, D13.
Value 1.3 in D5 is choose because it happen first.
Then count value 1.3 in Column E starting from row it happen in column D which is row 5 so count in E5 to E2

Expected result in Column L

p/s: Real data ranging from 1000-3000 rows

 

[Fluff]

How about

=COUNTIFS($B$2:INDEX(B:B,MATCH(E2,A:A,0)),E2)

 

[ibmy]

Thank you @Fluff so much for the solution.

 

[Fluff]

You're welcome & thanks for the feedback.