Formula for average of a top 12 numbers in a column of 24 total nu
 

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.

Formula for average of a top 12 numbers in a column of 24 total nu
 

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.

Formula for average of a top 12 numbers in a column of 24 tota
 

Awesome! The second works perfectly, thanks!

"Peo Sjoblom" wrote:

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.