Re: Ping Chip Pearson

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

No need to array enter.

Biff

"Ashish Mathur" <mathurashish@xxxxxxxxxxx> wrote in message
news:19127EF5-DF3C-4E0D-856D-7E7E934DF051@xxxxxxxxxxxxxxxx
> Hi,
>
> Another way to do it is as follows (Ctrl+Shift+Enter):
>
> =AVERAGE(LARGE(F4:F16,{1,2,3,4,5}))
>
> Regards,
>
> Ashish Mathur
>
> "Lomax" wrote:
>
>> I have a list of $ values in F4-F16 need to average the largest 5
>> amounts.
>>
>> I copied this from Your website and made a slight mod to accommodate the
>> 5
>> instead of 10 as on the site.
>> ={AVERAGE(LARGE(F4:F16,ROW(INDIRECT("1:5"))))}
>>
>> I understand all but the (indirect("1:5)). I hate to be a bother but
>> could
>> you explain this part? What does the indirect function perform?
>>
>> Thanks lomax
>>
>>
>>


.

Relevant Pages

  • Re: use a function for filtered data
    ... Microsoft Excel MVP ... "Ashish Mathur" wrote: ... we must thank Biff for sharing this solution. ... I need to filter how many of the weeks the activity> is ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Help!
    ... > I use Turnpike and only keep news for 3 days. ... > accumulate in the file but I doubt this amounts to much. ...
    (uk.business.agriculture)
  • Re: How do i create moving text within a cell?
    ... Biff ... > It's easier to beg forgiveness than ask permission :-) ... Prev by Date: ...
    (microsoft.public.excel.misc)
  • RE: extra results in the MAX function
    ... where A holds the months and B the amounts ... Regards, ... Peo Sjoblom ... Prev by Date: ...
    (microsoft.public.excel.worksheet.functions)
  • Re: tattslotto numbers
    ... Regards ... > Hi Biff ... > in my test scenario even this didn't work. ... > Frank Kabel ...
    (microsoft.public.excel)