Index(match) with multiple exact results

[Yoepy]

I have a list that index matches from a range from highest to lowest.

=INDEX($W$7:$W$14,MATCH(LARGE($X$7:$X$14,1),$X$7:$X$14,0),1)
=INDEX($W$7:$W$14,MATCH(LARGE($X$7:$X$14,2),$X$7:$X$14,0),1)
=INDEX($W$7:$W$14,MATCH(LARGE($X$7:$X$14,3),$X$7:$X$14,0),1)
=INDEX($W$7:$W$14,MATCH(LARGE($X$7:$X$14,4),$X$7:$X$14,0),1)

My problem is that I often have 2 or more results that are the same.

In this example the 3rd and 4th are the same. The above formulas results in:

Largest1
Largest2
Largest3
Largest3

How do I get it to go past the first 3rd largest and find the 4th Largest also.

Thanks in advance.

[AliGW]

One way is to introduce a helper column, that could be hidden:

Excel 2016 (Windows) 32 bit

	H	I	J
1		Helper
2	10	10.01	12
3	9	9.01	11
4	4	4.01	10
5	10	10.02	10
6	3	3.01	9
7	8	8.01	8
8	12	12.01	4
9	11	11.01	3

Sheet: Sheet1

Excel 2016 (Windows) 32 bit

	I	J
2	=H2+COUNTIF(H$2:H2,H2)/100	=INDEX($H$2:$H$9,MATCH(LARGE($I$2:$I$9,ROWS(J$2:J2)),$I$2:$I$9,0))

Sheet: Sheet1

[maras_mak]

Array formula (Ctrl + Shift + Enter)

Please Login or Register  to view this content.

Regards.

[Glenn Kennedy]

... or a non-array (... just use Enter) formula, with no helper column...

Please Login or Register  to view this content.

[Yoepy]

Thank you AliGW, maras and Glen.

I have sort of combined the 3 suggestions and added +ROW()/10^8 to the column being matched (column X). Works perfectly.