Excel 2007 : Need to create batting order depending on stats and can't have a player twice in line-up

I need it only to use a person once and if someone is leading 2 or more stat category I need it to just go to the next highest person.

I have 1 thru 11 batters 1-BA, 2-BA, 3-SLG, 4-SLG, 5-OPS, 6-OPS, 7 THRU 11-BA. The way I have Scott is in the line up 3 times it is in cell AB4 - AB 14. In yellow.