View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] ciojr@yahoo.com is offline
external usenet poster
 
Posts: 2
Default 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