Highest three numbers in a list
 

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?

--
Thanks,
Fred
Please reply to newsgroup, not e-mail

Hi Fred
I use this which is only marginally better.

=AVERAGE(LARGE(range,1),+LARGE(range,2),+LARGE(ran ge,3))
Have you had a look in the Archives??
HTH
Michael

"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?

--
Thanks,
Fred
Please reply to newsgroup, not e-mail

=AVERAGE(LARGE(Range,{1;2;3}))

entered with ctrl + shift & enter

--
Regards,

Peo Sjoblom


"Fred Smith" wrote in message
...
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?

--
Thanks,
Fred
Please reply to newsgroup, not e-mail

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?

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?