| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
dependent drop down - repeat values
In the Contextures example for €˜Data Validation -- Dependent Dropdowns from a
Sorted List what if there were several people with the same name from different regions? Can you make a €˜NameList €˜ and refer to it the same way as €˜RegionList and still have the dropdowns be dependent? I have three columns of data where values are repeated in each. This results in multiple drop down options on occasions where there should only be one. I greatly appreciate any advice you may have on fixing this. Dalgleish's website is great! Thank you, in advance. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Drop down list shrinks as you go down column | Excel Discussion (Misc queries) | |||
| with a drop down list in excel how do I select multiple values | Excel Discussion (Misc queries) | |||
| Setting default values in a drop down list in excel? | Excel Discussion (Misc queries) | |||
| How do I assign a set of values to a selection from a drop list? | New Users to Excel | |||
| Refreshing drop down cell values... | Excel Worksheet Functions | |||
Threaded Mode
