VBA Unique list, sum if, then sort by largest

[jcooooper]

Morning all,

What's the most efficient/stable way to achieve the following

Create a unique list from Named_range_1 in A1

then in column B down to the last value in column A

SUMIF(Named_range_2,B1, Named_range_3)

Then sort columns A and B by column B, largest to smallest

Column A is text and B values.

Any help will be muchos appreciated.

Cheers!