Checking for dublication of text
 

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?


--
Hormes
------------------------------------------------------------------------
Hormes's Profile: http://www.excelforum.com/member.php...o&userid=28919
View this thread: http://www.excelforum.com/showthread...hreadid=486631

Checking for dublication of text
 

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
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"Hormes" wrote in
message ...

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?


--
Hormes
------------------------------------------------------------------------
Hormes's Profile:
http://www.excelforum.com/member.php...o&userid=28919
View this thread: http://www.excelforum.com/showthread...hreadid=486631

Checking for dublication of text
 

Thanks Max...

This was exactly what I was looking for...


--
Hormes
------------------------------------------------------------------------
Hormes's Profile: http://www.excelforum.com/member.php...o&userid=28919
View this thread: http://www.excelforum.com/showthread...hreadid=486631

Checking for dublication of text
 

Glad the lead helped.
Thanks for the feedback ..
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"Hormes" wrote in
message ...

Thanks Max...

This was exactly what I was looking for...