Sirpeterjones
New Member
- Joined
- Mar 30, 2011
- Messages
- 9
Assuming that you have a recent version with the functions that I have used, and that you have at least 10 scores, you could try this. The formula has averaged the green cells.average of the best 10 scores in last 20 games of golf
23 04 17.xlsm | |||||
---|---|---|---|---|---|
C | D | E | |||
1 | Score | Av best 10 of last 20 | |||
2 | 71 | 75.5 | |||
3 | 73 | ||||
4 | 84 | ||||
5 | 78 | ||||
6 | 76 | ||||
7 | 89 | ||||
8 | 76 | ||||
9 | 76 | ||||
10 | 74 | ||||
11 | 84 | ||||
12 | 78 | ||||
13 | 84 | ||||
14 | 72 | ||||
15 | 92 | ||||
16 | 83 | ||||
17 | 92 | ||||
18 | 88 | ||||
19 | 78 | ||||
20 | 79 | ||||
21 | 71 | ||||
22 | 83 | ||||
23 | 78 | ||||
24 | 76 | ||||
25 | |||||
26 | |||||
Average best 10 of last 20 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
E2 | E2 | =LET(r,C2:C100,AVERAGE(INDEX(SORT(INDEX(FILTER(r,r<>""),SEQUENCE(20,,COUNT(r),-1))),SEQUENCE(10)))) |