Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Resetting default row height to allow display of wrapped text | New Users to Excel | |||
Text shown up in other cells everytime a text is entered in 1 cell | Excel Discussion (Misc queries) | |||
Finding Specific Text in a Text String | Excel Worksheet Functions | |||
SUMPRODUCT vs Text??? | Excel Worksheet Functions | |||
Read Text File into Excel Using VBA | Excel Discussion (Misc queries) |