Don't want to repeat a selection

[Gary C]

I have a sheet for a sports team. When making the lineup I select the
players from a drop down list.
How do I format the cell to not repeat a name that is selected in a cell?

 

[Bob Phillips]

Take a look at http://www.contextures.com/xlDataVal03.html

--

HTH

RP
(remove nothere from the email address if mailing direct)