Top 3 names based on values

[sidd.iths]

Hi,

I have a dataset which comprises of multiple entries as shown below:

Name Score
A 1
B 2
C 3
D 4
B 5
A 6
D 7
C 8

There are multiple such entries and I need to extract the top 2 names based on the sum of their scores.

Sid

[alansidman]

Using Power Query here is the Mcode

Please Login or Register  to view this content.

Are you still using 2007. If not, please update your profile. If you are still using XL2007, then you will probably need an alternative solution.

[sidd.iths]

Hi,

Thanks for this, I was looking at solving this through VBA.

Any help would be great!