Top 5 Largest Amounts - Multiple Variables

[s1specken]

I'm having trouble figuring out how to pull together a top 5/bottom 5 list, given the way the data is provided. The source data is pulled from an existing macro, which I dare not alter, so that is unavoidable. Basically, I am trying to pull the names (column A) and sale amounts (column B), into a table to show the top 5 largest amounts. My problem is that there are names with multiple rows of data. For example "Company A" has 3 different rows of sale amounts (20,30,40), which would give them a total of 90 for sale amounts. I want that total to be taken into account when ordering the top 5, rather than each row individually. Is there a way to do this without first creating a seperate table that sums the data?

 

[Andrew Poulsom]

Have you tried a Pivot Table and its Top 10 feature?

 

[s1specken]

Have you tried a Pivot Table and its Top 10 feature?

I'm not familiar with that feature? Where do I find that in Excel 2010? Thansk in advance!

 

[Andrew Poulsom]

Google is your friend.

http://www.contextures.com/excel-pivot-table-filters-top10.html