ExcelBanter - need to find highest total

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - need to find highest total (https://www.excelbanter.com/excel-programming/375821-need-find-highest-total.html)

[email protected]

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

Gary''s Student

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

All times are GMT +1. The time now is 02:07 AM.