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
|