best 20 results to obtain the highest average

[coll]

Can you please help with a formula for a games spreadsheet.

A player could have a line of say 30 or more results this could include blank cells, How can I use only the best 20 results to obtain the highest average.

Thanks for any assistance

[rylo]

Hi

say your data is in the range A4:A33 then try

=AVERAGE(IF(A4:A33=LARGE(A4:A33,COLUMN(A1:T1)),A4:A33,""))

This formula is array entered (ctrl, shift, enter)


rylo