VBA for top 5 entries by sum of groups

[Chujaixd]

Hi all

I am trying to analyse the following dataset and get the total amount of first 5 items of each group(2 grps in total).

I tried to use sumifs but since there are too many unique items in my data, selecting and filtering makes the table too complicated.

Thanks for the help in advance!

Input
Name.....Group.....Amount
AAA.....1..........10
AAA.....1..........20
AAA.....2..........40
BBB.....2..........50
CCC.....1..........60

Output
Name.....Group.....Amount
CCC....1..........60
AAA.....1..........30
BBB.....2..........50
AAA.....2..........40

 

[JefferyLi]

Do you need a VBA code for this?

If not, I think this way should work:
1. combine name and group like "CCC - 1", "AAA - 2"......etc
2. a pivot table

 

[Chujaixd]

Do you need a VBA code for this?

If not, I think this way should work:
1. combine name and group like "CCC - 1", "AAA - 2"......etc
2. a pivot table

I was asked to do it with the vba thanks for your help

 

[JefferyLi]

Will that work if VBA do the same steps as below?

1. combine name and group like "CCC - 1", "AAA - 2"......etc
2. a pivot table
3. sort amount from largest to smallest