Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Check for duplicate entries in pull-down list
I have a column in which the cells are a pull-down list that already uses
data validation to get entries from a column on another worksheet (The values entered are phone numbers.). I would like to also check this column for duplicates upon entry (from the pull-down list) so that the same phone number does not get assigned to two people. It does not appear to be possible to use two different types of data validation on the same set of cells. Since data validation sets up the list, how can I check for duplicate entries? Thanks in advance for any help. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Check for duplicate entries in pull-down list
I'd probably put a conditional format so that if there are duplicates, the
color of the cell (or row) would change. Check out this link for more info http://office.microsoft.com/en-us/ex...366161033.aspx HTH, Barb Reinhardt "bbarkman" wrote: I have a column in which the cells are a pull-down list that already uses data validation to get entries from a column on another worksheet (The values entered are phone numbers.). I would like to also check this column for duplicates upon entry (from the pull-down list) so that the same phone number does not get assigned to two people. It does not appear to be possible to use two different types of data validation on the same set of cells. Since data validation sets up the list, how can I check for duplicate entries? Thanks in advance for any help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
make a list from another list ignoring duplicate entries from orig | Excel Worksheet Functions | |||
check a list of numbers for duplicate entries in Excel | Excel Discussion (Misc queries) | |||
how can I check a worksheet for duplicate entries or numbers? | Excel Worksheet Functions | |||
How do I remove duplicate entries from a list? | Excel Discussion (Misc queries) | |||
Duplicate entries in an excel list? | Excel Discussion (Misc queries) |