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
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(range,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" <[email protected]> wrote in message
news:[email protected]...
>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 <[email protected]>,
"Fred Smith" <[email protected]> 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" <[email protected]> wrote in message
news:[email protected]...
> Try...
>
> =AVERAGE(LARGE(Range,{1,2,3}))
>
> Hope this helps!
>
> In article <[email protected]>,
> "Fred Smith" <[email protected]> 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?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks