Forum Discussion
Array formula
I am trying to figure out how to select the average of the 10 largest numbers from among the group of numbers represented between C2 and V2. In other words how do you determine the AVERAGE of the 1...
Assuming you have at least 10numbers to average this would work
=AVERAGE(LARGE(C2:V2,ROW(1:10)))
enter it as an array. it wont work if there are less than 10numbers in c2:v2 so you could wrap it up in a iferror =IFERROR(AVERAGE(LARGE(C2:V2,ROW(1:10))),"Not enough scores submitted")