# Large, Index, Match, Different Names Same Values

#### lmpzkt

##### New Member
Hi

I have named the columns as below...

And using LARGE function to get the top 5 values arrangement

And using INDEX & MATCH to match each score with its name

The problem here that I found duplicated names for the same score, but what I need as follows...

Name D Score 7 which is the first name gets 7 in column
Name G Score 7 which is the second name gets 7 in column
Name I Score 7 which is the third name gets 7 in column
Name B Score 5 which is the first name gets 5 in column
Name F Score 5 which is the second name gets 5 in column

How could I do this, please?

Thanks

### Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.
Lots of No Entry signs.

In E2 & filled down try
=INDEX(Name,AGGREGATE(15,6,(ROW(Name)-ROW(\$A\$2)+1)/(Score=F2),COUNTIF(\$F\$2:F2,F2)))

@Special-K99
Not sure what you are seeing, but I can see the posted images.

Last edited:
Yes, even I am not able to see the images.

Cold you please post it again

It can be viewed by Chrome browser

Sorry, this is my first post so I uploaded images on google photos

Odd, I could see them originally, but all I see now is a broken link image.

@Impxkt
Did you see the formula I suggested in post#3

In E2 & filled down try
=INDEX(Name,AGGREGATE(15,6,(ROW(Name)-ROW(\$A\$2)+1)/(Score=F2),COUNTIF(\$F\$2:F2,F2)))

It worked but it complicated to apply it on another excel sheet because I'm not fluent in functions and I had to change "," to ";" to work.

I see that you use AGGREGATE and COUNTIF instead of MATCH

With data on sheet 1

Excel 2013/2016
AB
1NameScore
2A8
3B5
4C9
5D7
6E6
7F5
8G7
9H4
10I7
Sheet1

And results

Excel 2013/2016
AB
1NameTop5
2C9
3A8
4D7
5G7
6I7
7E6
8B5
9F5
10H4
Calc
Cell Formulas
RangeFormula
A2=INDEX(Name,AGGREGATE(15,6,(ROW(Name)-ROW(\$A\$2)+ROW(A\$1))/(Score=B2),COUNTIF(B\$2:B2,B2)))
B2=LARGE(Score,ROWS(\$1:1))
Named Ranges
NameRefers ToCells
Name=Sheet1!\$A\$2:\$A\$10
Score=Sheet1!\$B\$2:\$B\$10

Replies
3
Views
448
Replies
10
Views
304
Replies
9
Views
298
Replies
16
Views
260
Replies
5
Views
622

1,207,111
Messages
6,076,624
Members
446,216
Latest member
BEEALTAIR

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back