Re: Highest three numbers in a list

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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

entered with ctrl + shift & enter

--
Regards,

Peo Sjoblom


"Fred Smith" <fredsmith99@xxxxxxxxx> wrote in message
news:ugtYkYuRFHA.2964@xxxxxxxxxxxxxxxxxxxxxxx
>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
>
>
>


.

Relevant Pages

  • RE: Function "Networkdays"
    ... entered with ctrl + shift & enter ... Regards, ... Peo Sjoblom ... > I've used this function successfully to calculate the number of business days ...
    (microsoft.public.excel.worksheet.functions)
  • RE: Remove text leading zero in text string
    ... Enter the formula with ctrl + shift & enter ... Regards, ... Peo Sjoblom ...
    (microsoft.public.excel.worksheet.functions)
  • RE: Average If
    ... Did you enter it with ctrl + shift & enter or does any of your ranges include ... a #NUM! ... >> Regards, ... >> Peo Sjoblom ...
    (microsoft.public.excel.misc)
  • RE: ARRAY FORMULA-RETURN 0 INSTEAD OF #DIV/0
    ... entered with ctrl + shift & enter ... Regards, ... Peo Sjoblom ... "Teri" wrote: ...
    (microsoft.public.excel.worksheet.functions)
  • RE: Average If
    ... array entered ctrl + shift & enter ... Regards, ... Peo Sjoblom ... "Denise" wrote: ...
    (microsoft.public.excel.misc)