nTH largest values, when more than one of the same

[surkdidat]

I am using a formula to look up the highest number in column B, and then an INDEXMATCH to look at the names in column A

So =LARGE(B2:B100,1)

and then

=LARGE(B2:B100,2)

etc

On this, I am doing an INDEX MATCH to look at the associated name in column A

However, if 2 people, have say 27 in column B, the INDEX-MATCH, is only bringing up the first instance, so if in A1 we had Peter, and B1 27, and in A2 we had Lola, and in B2 was also 27, its not then ignoring the first instance, and bringing up the second instance on the next line

How do I go about the INDEX MATCH always bypassing any previous matches please?

 

[Fluff]

Can you post some sample data.

MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.

 

[surkdidat]

Apologies, in on a work laptop, so cannot install, I have posted some sample data below and a required output below that

Details in spreadsheet

Column A (Name)	Column B (Score)
Peter	27
Lola	27
Bella	28
Andy	26

Hopeful Output

Column A (Placing)	Column B (Name)	Column c (Score)	Current formula used for Column B	Current formula used for Col C
1	Bella	28	=INDEX(A:A,MATCH(A1,B:B,0))	=LARGE(B2:B100,1)
2	Peter	27	=INDEX(A:A,MATCH(A2,B:B,0))	=LARGE(B2:B100,2)
3	Lola	27	=INDEX(A:A,MATCH(A3,B:B,0))	=LARGE(B2:B100,3)
4	Andy	26	=INDEX(A:A,MATCH(A4,B:B,0))	=LARGE(B2:B100,4)

 

[Fluff]

How about

Fluff.xlsm
	A	B	C	D	E	F
1
2	Peter	27			28	Bella
3	Lola	27			27	Peter
4	Bella	28			27	Lola
5	Andy	26			26	Andy
Data

Cell Formulas
Range	Formula
E2:E5	E2	=LARGE($B$2:$B$5,ROWS(E$2:E2))
F2:F5	F2	=INDEX(A:A,AGGREGATE(15,6,ROW($A$2:$A$5)/($B$2:$B$5=E2),COUNTIFS(E$2:E2,E2)))

 

[surkdidat]

How about

Fluff.xlsm
	A	B	C	D	E	F
1
2	Peter	27			28	Bella
3	Lola	27			27	Peter
4	Bella	28			27	Lola
5	Andy	26			26	Andy
Data

Cell Formulas
Range	Formula
E2:E5	E2	=LARGE($B$2:$B$5,ROWS(E$2:E2))
F2:F5	F2	=INDEX(A:A,AGGREGATE(15,6,ROW($A$2:$A$5)/($B$2:$B$5=E2),COUNTIFS(E$2:E2,E2)))

Absolutely perfect! Thanks once again!

 

[Fluff]

You're welcome & thanks for the feedback.