Keep returns from duplicating (softball batting lineup based on stats)

That helps some but in the sabermetrics column I need to collect stats from several different columns to create the lineup without duplicating a player. For example, E20 would draw it's info from the SLUG column and E18 would draw it's info from the AVG column. If both of those cells happen to return the same player using the LARGE formula how do I keep Excel from duplicating the player and picking the best remaining player instead.

Right know I mainly need assistance with the sabermetric column. Since there are only 12 girls on the team the formulas used in E17 thru E28 cant allow any duplicating names even though each cells return needs to come from a different column. I'm familiar with the Large function to get the "Nth" number from each category, the part I'm struggling with is, if a player has the SLUG# and the best OBP every formula I've tried will put her in both the #1 slot and the #4 slot which cant happen since each player can only bat once per inning. So the breakdown should go as follows to get the optimal batting lineup.
SABERMETRIC RANKING
E17/best OBP that is not best OPS or best SLG
E18/best OPS that is not best SLG
E19/5th best batting average
E20/best SLG
E21/best remaining SLG
E22/best remaining OBP
E23/worst AVG
E24/best remaining OBP
E25/best remaing OPS
E26/best remaining SLG
E27/best remaining OBP
E28/best remaining OPS

Hope this makes more sense cause I cant really think of any other way to describe it.