Details inside...

[Zippy]

I couldn't think of a good Subject Line:

Basically, I have multiple sheets where team/individual competition scores are calculated. I then have a summary page. On the summary page I am sorting out the winners, both in score and team name. Now I want to be able to eliminate a winner and go to the 2nd or 3rd or further if needed based on a range of cells containing a "Y". The range containing the "Y" is on each individual sheet.

So if a "Y" is located in the range then go to the 2nd highest score, if a "Y" is in the range for the 2nd go to the 3rd and so on.

Is this possible? Does my question make any sense?

I am more than happy to send the file to you if necessary.

Thanks in advance.

 

[Gates Is Antichrist]

I think you've worked out the logic. It sounds like the SMALL function has the nirvanization you desire