This will average the top 12 largest numbers


=AVERAGE(LARGE(A1:A24,{1;2;3;4;5;6;7;8;9;10;11;12} ))


=AVERAGE(LARGE(A1:A24,ROW(INDIRECT("1:12"))))


this formula is volatile


or if you never insert rows above the data


=AVERAGE(LARGE(A1:A24,ROW(1:12)))


the 2 latter formulas need to be entered with ctrl + shift & enter





--

Regards,

Peo Sjoblom


"Sean" wrote in message
...
I have a list of 2 games played per month. I'd like to take the average of
the top 12 games of the 24 listed with out having to resort them (I want
to
keep them in the order of the months). Is there a way to do this?

It's giving me a lot of stress digging around and trying to find an
answer.
This has had to come up before. Thanks in advance.