"georgeb" wrote in message
...
What function will find the average of the k largest numbers in an array
of n
numbers?

Perhaps something like:

=AVERAGE(LARGE(A1:A10,ROW(1:4)))

entered as an array formula with <Ctrl <Shift <Enter. This will give you
the average of the 4 largest numbers in the range A1:A10.

--

Vasant