Hi!

You don't need the Indirect:

=AVERAGE(LARGE(A1:A60,ROW($1:$10)))

Making the ROW argument absolute does the same thing as Indirect.

Biff

"T De Villiers" <T.De.Villiers.1vnjqb_1127210724.3351@excelforum-nospam.com>
wrote in message
news:T.De.Villiers.1vnjqb_1127210724.3351@excelforum-nospam.com...
>
> =AVERAGE(LARGE(A1:A60,ROW(INDIRECT("1:10"))))
>
> This array formula averages the 10th largest values in the Range
> A1:A60,
> I understand it:
>
> so its taking the average value of
>
> LARGE(A1:A60,1), LARGE(A1:A60,2), LARGE(A1:A60,3)..........
>
> But how does ROW(INDIRECT("1:10") return the array 1,2,3,....
>
>
> Thanks
>
>
> --
> T De Villiers
> ------------------------------------------------------------------------
> T De Villiers's Profile:
> http://www.excelforum.com/member.php...o&userid=26479
> View this thread: http://www.excelforum.com/showthread...hreadid=469109
>