Checking for dublication of text

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Hormes - 20 Nov 2005 09:02 GMT

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?

Signature

Hormes

Reply to this Message

Max - 20 Nov 2005 10:34 GMT

> 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
--

> I’m using a dropdown list with names listed, once the name is placed in
> any field it may not be selected again.
[quoted text clipped - 7 lines]
> Hormes's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=28919
> View this thread: http://www.excelforum.com/showthread.php?threadid=486631

Reply to this Message

Hormes - 21 Nov 2005 01:34 GMT

Thanks Max...

This was exactly what I was looking for...

Signature

Hormes

Reply to this Message

Max - 21 Nov 2005 02:17 GMT

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

> Thanks Max...
>
> This was exactly what I was looking for...

Reply to this Message