Count number of occurence of value with condition

[ibmy]

Hi,

Sample of data:

1.11.xlsb
	B	C	D	E	F
1	A	B		A	Expected Result
2	1.3	1.2		1.3	4
3	1.3	11.9		11.9	2
4	1.2	1.2
5	11.9	1.3
6	1.2	1.2
7	11.9	11.9
8	11.9	1.3
9	1.3	65.7
10	11.9	11.9
11	11.9	1.3
12	11.9	7.8
13	1.2	11.9
14	1.2	11.9
15	1.2	11
16	65.7	7.8
17	65.7	1.3
18	8.9	11.9
19	6.6	1.3
20	88	1.2
21	4	1.3
Sheet3

Before counting number of occurence value in Column E, these 2 steps must follow :

Step 1) Locate value Column E in Column B, it must exist last (if from top to down) or exist first (from down to top)
Example: E1 value is "1.3", it occur in B2, B3, B9.
B9 is choose because it exist last in column B (from top to down) or exist first in column B (from down to top)

Step 2) Then, count number of occurence the value in Column C, starting from row of it occur in column B (Step 1)
Example: Value "1.3" happen last in B9 so count the number of occurence in Column C starting form C9 to last row in Column C

Properties of Real Data:
1. Row data in Column B and C ranges 100k-450k , for now "countif" works fine but my problem how to do Step 1.
2. Number mostly are in decimal point (3-5 decimal points), Column B, C, E

p/s: sorry for bad English

 

[Alex Blakenburg]

You're welcome. Appreciate the feedback.