Large, Index, Match, Different Names Same Values

[lmpzkt]

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

 

[Special-K99]

Unreadable content, check your posting.
Lots of No Entry signs.

 

[Fluff]

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.

 

[sunilbsrv2k]

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

Cold you please post it again

 

[Special-K99]

Grey "No Entry" signs
Like this with no background

https://www.google.co.uk/search?q=g...UIDigB&biw=1440&bih=723#imgrc=fqTDK6wNt86nTM:

 

[lmpzkt]

It can be viewed by Chrome browser

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

 

[Fluff]

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

 

[lmpzkt]

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

 

[Fluff]

With data on sheet 1

Excel 2013/2016
	A	B
1	Name	Score
2	A	8
3	B	5
4	C	9
5	D	7
6	E	6
7	F	5
8	G	7
9	H	4
10	I	7
Sheet1

And results

Excel 2013/2016
	A	B
1	Name	Top5
2	C	9
3	A	8
4	D	7
5	G	7
6	I	7
7	E	6
8	B	5
9	F	5
10	H	4
Calc

Cell Formulas
Range	Formula
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
Name	Refers To	Cells
Name	=Sheet1!$A$2:$A$10
Score	=Sheet1!$B$2:$B$10