Excel Fox
04-16-2011, 04:15 PM
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)))}
24
24
View Full Version : Average Of The X Largest Numbers