Extracting a Result Based on a Condition

**andrewc** · 02-06-2015, 11:29 AM

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!

**AlKey** · 02-06-2015, 12:04 PM

Here is an example that maybe helpful to you

Step 1
in D2 use this formula to get unique list of names:

=IFERROR(INDEX($A$2:$A$11,MATCH(0,INDEX(COUNTIF(D$1:D1,$A$2:$A$11),,),)),"")

Step 2

use this formula in C2

=SUMIF($A$2:$A$11,D2,$B$2:$B$11)

then apply filter to the fist row and filter out by: "Sort Largest to Smallest"