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