If Column A contains your numbers, say from Row 1 to 10, to find the average of the 5 largest numbers, use the Array Formula (CTRL+SHIFT+ENTER) {=AVERAGE(LARGE(A1:A10,ROW(1:5)))}
Attachment 24
Printable View
If Column A contains your numbers, say from Row 1 to 10, to find the average of the 5 largest numbers, use the Array Formula (CTRL+SHIFT+ENTER) {=AVERAGE(LARGE(A1:A10,ROW(1:5)))}
Attachment 24