Checking for dublication of text

[Hormes]

I’m using a dropdown list with names listed, once the name is placed in
any field it may not be selected again.
Can I automatically check for double entries and indicate as such?
Or perhaps eliminate the names from the list once they have been
selected?

 

[Max]

Or perhaps eliminate the names from the list

once they have been selected?

Think Debra Dalgleish has a nice coverage on this at her:
http://www.contextures.com/xlDataVal03.html
Data Validation -- Hide Previously Used Items in Dropdown

 

[Hormes]

Thanks Max...

This was exactly what I was looking for...

 

[Max]

Glad the lead helped.
Thanks for the feedback ..