My problem is that I have a list of 20K agreement numbers. Each agreement has a supplier name and spend associated with the agreement. Every agreement has a unique ID however one supplier might have multiple agreement numbers.

I would like to have a table created that has the top suppliers based on spend. Top agreement by spend I can do, but when it comes to supplier where I have to group the spend, that's where I get messed up.

I however don't want a vlookup because there are filterings on top of that, which is not shown in the example spreadsheet attached.

Grouping Data.xls