Thanks guys. I knew there was a better way.
--
Regards,
Fred
Please reply to newsgroup, not e-mail
"Domenic" wrote in message
...
Try...
=AVERAGE(LARGE(Range,{1,2,3}))
Hope this helps!
In article ,
"Fred Smith" wrote:
I need the average of the highest three amounts in a range. I'm currently
using:
=(large(range,1)+large(range,2)+large(range,3))/3
Is there an easier way?
|