Ping Chip Pearson
No need to array enter.
Biff
"Ashish Mathur" wrote in message
...
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
|