Hi,

In column A I have a list of names, many occurring more than once.

In column B there is a value associated with each name in column A.

Can someone please suggest a formula that will return the nth-largest name by its total summed value in column B

So, for example, if there are 10 instances of the name “John” in column A, each with a value of 1 in column B (so “John” has a total of 10), and if 10 is the largest summed value per name, then my formula would return “John” as the first result. If all values associated with “Paul” sum to 9, then “Paul” would return as the second result, etc.

Thanks!