Using the array constant allows the above formula to equate as a regular
formula!
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Ragdyer" wrote in message
...
=AVERAGE(LARGE(A1:A10,{1,2,3}))
--
HTH,

RD

--------------------------------------------------------------------------
-
Please keep all correspondence within the NewsGroup, so all may benefit !
--------------------------------------------------------------------------
-
"georgeb" wrote in message
...
What function will find the average of the k largest numbers in an array
of n
numbers?