need to find highest total

  • Thread starter Thread starter ciojr
  • Start date Start date
C

ciojr

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

HOW TO TOTAL THE THREE HIGHEST AMOUNTS IN A ROW 2
Finding highest values 1
Need to find the 2 highest numbers for each person? 6
How to equally weight variables 2
Search row of numbers, find highest value. 2
5 highest then list names 5
Query to display highest totals 1
Finding (Multiple) Highest Values in Column 1

Back
Top