Return top 3 values and their correspondence

**RandomP** · 11-10-2011, 12:08 PM

Hello there,

In the following sheet I have a number of brands with their respective scores (not ordered by scores). I need to extract the top 3 brands in separate cells. I have tried combinations of LARGE, MATCH, INDEX formulas, however I got stuck. The main problem is the fact that the scores column does not have unique scores (for example 2 brands have the same score).

Any help would be very appreciated.

Thank you all in advance.

**NBVC** · 11-10-2011, 12:18 PM

Is there a likelihood of duplicate values in column C?

**jeffreybrown** · 11-10-2011, 12:24 PM

Maybe with a helper column (Column D), add a helper column to rank your list.

D1=RANK(C2,$C$2:$C$13,0)+COUNTIF($C$2:C2,C2)-1

Then in F2 copied down

F2=INDEX($B$2:$B$13,MATCH(ROW(A1),$D$2:$D$13,0))

**RandomP** · 11-11-2011, 09:29 AM

Thank you jeffreybrown,

It works that way, even if it's a little more work to do. I have not one, but maybe 50 ranking to do.

But thank you nonetheless.

**jeffreybrown** · 11-11-2011, 11:13 AM

You are very welcome...Glad it worked out for you

Undoubtedly NBVC can come up with something without a helper column, but make sure you post your exact requirements as every situation will required a slightly different solution.