Hi!
A non array entered version:
=AVERAGE(LARGE(A1:A100,{1,2,3,4}))
Of course, if you wanted the largest 50 you wouldn't want to use the above
method!
Another method:
=SUMIF(A1:A100,"="&LARGE(A1:A100,4))/4
Biff
"georgeb" wrote in message
...
What function will find the average of the k largest numbers in an array
of n
numbers?
|