| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
validation list with no duplicates
You have to create a 2nd list that contains just the unique entries.
One way to do that is to use the Advanced Filter to extract the unqiues and choose to copy those uniques to another location. Then use that new range location as the source for the drop down. Biff "Rodrigo Ferreira" wrote in message ... Hi, How can I create a validation list with no duplicates? I have the list: A ABC DEF GHI ABC DEF ZXC ... On B3 I want a validation list with: ABC DEF GHI ZXC How can I do this? -- Rodrigo Ferreira |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| duplicates in validation list combobox | Excel Discussion (Misc queries) | |||
| data validation invalid in dynamic validation list | Excel Discussion (Misc queries) | |||
| Array Formulas - Unique List from List with Duplicates | Excel Discussion (Misc queries) | |||
| Duplicates in database validation | Excel Discussion (Misc queries) | |||
| How to remove duplicates from a list and copy new list to new colu | Excel Worksheet Functions | |||
Threaded Mode
