It could be added to a macro to automate it, even by just doing keystrokes, but if you run a pivot table report with names as rows and the sum of the values as the values this will give you the totals for each name

This table can then be sorted by the value column and then you have your result

So once you have set it up, if your range is big enough to include any new entries that you may add when you set up the pivot. You just need to refresh and then sort and then if you wished copy the top 20 rows to whereever you want in your report. It would be better to create by pressing a button, otherwise it would recalcualte everytime you added a new entry and this would not be an efficient use of resource.

Regards

Dav


Regards

Dav