I am attempting to build a soccer position/lineup worksheet that will allow
me to not have any DUPLICATE players on the field at a given time.

How do I best accomplish this? Is it possible within Excel to do this?