View Single Post
  #5   Report Post  
Biff
 
Posts: n/a
Default

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?