Average bottom 10 results in last 20 games

[Sirpeterjones]

Please can I get some help on formula to calculate the average of the best 10 scores in last 20 games of golf. Excel table has 20 results and I need to calculate the average of the best 10 of those 20 please

 

[nemmi69]

The top 10. Change before the comma to your range, after to that cell. Then drag down the required number to show. For lowest change LARGE to SMALL

 

[James006]

Hi,

With your scores in Column C

=AVERAGE(LARGE($C$2:$C$50,ROW(1:10)))

 

[Peter_SSs]

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

average of the best 10 scores in last 20 games of golf

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.

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))))

 

[Fluff]

Another option if you have 365 with the latest functions

=AVERAGE(TAKE(SORT(TAKE(FILTER(I2:I500,I2:I500<>""),-20)),10))