Hello,

I have the following sample of data in columns D & E
1.33 CCMO
1.21 ALLY
1.21 MGM
1.14 DISH
1.57 ALLY
0.25 MGM
0.25 CNK

The list goes on for 200 lines. What I'm trying to do is in one clean function be able to sum the numbers in column D associated with the names in column E and return the top 5 (or 10). Ideally it would return the following on seperate cell for each:
2.78 ALLY
1.46 MGM
1.33 CCMO
1.14 DISH
0.25 CNK

Does anyone know a function to do that? I've tried a lot, but can't get it to work.

Thanks in advance