Hi could someone adjust this formula so it would count the last 5 occurrences ?
My data sheet has over 10,000 rows, have just shown small example
have attached photo for better understanding
My data sheet has over 10,000 rows, have just shown small example
have attached photo for better understanding
Book1 | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
C | D | E | F | G | H | I | J | |||
2 | PETER | 3 | ||||||||
3 | 5 | |||||||||
4 | ||||||||||
5 | ||||||||||
6 | ||||||||||
7 | ||||||||||
8 | ||||||||||
9 | PETER | 12 | ||||||||
10 | PETER | 1 | ||||||||
11 | PETER | 3 | ||||||||
12 | PETER | 2 | 14 | |||||||
13 | PETER | 2 | 15 | |||||||
14 | DAN | 8 | ||||||||
15 | DAN | 2 | ||||||||
16 | DAN | 1 | ||||||||
17 | DAN | 4 | ||||||||
18 | PAUL | 4 | ||||||||
19 | PETER | 12 | ||||||||
20 | PETER | 1 | ||||||||
21 | PETER | 3 | ||||||||
22 | PETER | 1 | 12 | |||||||
23 | PETER | 12 | ||||||||
24 | PETER | 1 | ||||||||
25 | PETER | 3 | ||||||||
26 | PETER | 2 | 14 | |||||||
Sheet1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
J2 | J2 | =COUNTIFS($C$1:$C$9971,$F$2,$D$1:$D$9971,"",$E$1:$E$9971,">="&$F$3) |