| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
need to find highest total
withouth using the subtotal or autofilter functions, how can I find the
highest scores using the following data 152 Joe One 10 Sam Egg 152 Sam Egg 10 Sam Egg 76 Jim Cat 40 Adam Three 72 Adam Three I want to find the person with the highest total of scores and display it So in the example - Sam Egg would win with a total of 172 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
need to find highest total
Use a Pivot Table.
-- Gary's Student " wrote: withouth using the subtotal or autofilter functions, how can I find the highest scores using the following data 152 Joe One 10 Sam Egg 152 Sam Egg 10 Sam Egg 76 Jim Cat 40 Adam Three 72 Adam Three I want to find the person with the highest total of scores and display it So in the example - Sam Egg would win with a total of 172 |
| 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 | |||
| Summation of 25 highest values out of total data of 35 | Excel Discussion (Misc queries) | |||
| 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 | |||
| Highlighting Highest Total | Excel Discussion (Misc queries) | |||
Linear Mode
