# Sort and group names, then sum associated numerical values for each group, sort total

1. ## Sort and group names, then sum associated numerical values for each group, sort total

I don't know if Excel can do this, but I'd bet it can. Anyway, the best way to explain the question is by illustration I believe.

So, I have this massive spreadsheet, with the maximum rows excel will fit on one sheet. In the interest of simplicity, this is what the raw data looks like:

Last First Amount

Jones Jim \$1000
Jung Joe \$700
White Jon \$100
Jones Jim \$200
Jones Jan \$300
Jung Joe \$800
White Jon \$200

What I want to do is automatically get excel to group all the same names together. Then I want it to sum all the values for each name, then order by largest total value for each person, then order that by name alphabetically. In other words, the above would look like this after the sort:

Last First Amount
Jung Joe \$800
Jung Joe \$700
Jones Jim \$1000
Jones Jim \$200
Jones Jan \$300
White Jon \$200
White Jon \$100

Or, if necessary, there could be sum total rows under each name...although I don't have spare rows, so IDK. I could delete some rows if I had to, but would rather not.

Hopefully this makes sense. Any help would be greatly appreciated.

2. ## Re: Sort and group names, then sum associated numerical values for each group, sort total

If I were doing this, I would use a Pivot Table. Look at this link for tutorials on Pivot Tables if you are unfamiliar.

http://www.datapigtechnologies.com/ExcelMain.htm

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1