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.
Bookmarks