Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to average a column of numbers that are greater than 0? | Excel Worksheet Functions | |||
Total instances of the same numbers from one column? | Excel Worksheet Functions | |||
Sum/average numbers in column A dependant on value in column B | Excel Worksheet Functions | |||
Average first 3 numbers in column e.g. 130 in 130/82 | New Users to Excel | |||
Pivot Table -- Add column to average Grand Total | Excel Worksheet Functions |