Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Summation of 25 highest values out of total data of 35
Hi,
I have a data of 35 values and I want to consider only top 25 values. Data is spread as 35 agents and their scores across 3 months (in Pivot) so cannot use Sort function each and Every time. Please help. Manoj. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Summation of 25 highest values out of total data of 35
On Tue, 1 Mar 2011 23:52:43 -0800 (PST), Manoj Shedbalkar wrote:
Hi, I have a data of 35 values and I want to consider only top 25 values. Data is spread as 35 agents and their scores across 3 months (in Pivot) so cannot use Sort function each and Every time. Please help. Manoj. How best to do this depends on information you have not yet shared with us, such as your data layout, and Excel version. For example, if your values are in column A, and your dates in column B, and you want to find the average of the top 25 for the fourth quarter of 2010, and your Excel version is 2007 or later, you could use: =AVERAGEIFS(A:A,A:A,"="&LARGE(A:A,25),B:B,"=" & DATE(2010,9,1),B:B,"<="&DATE(2010,12,31)) Formulas also exist for earlier versions and this could be modified to include different ranges or criteria. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Highest total of any three consecutive numbers in a range. | Excel Worksheet Functions | |||
HOW TO TOTAL THE THREE HIGHEST AMOUNTS IN A ROW | Excel Discussion (Misc queries) | |||
Total the highest 5 of 8 amounts. | New Users to Excel | |||
Sorting names and numbers in order with the highest total | Excel Worksheet Functions | |||
Highlighting Highest Total | Excel Discussion (Misc queries) |