In that example, the Region column is sorted, and the list of valid
names for each region appears in the cell with dependent data validation.

You could change it so the list is sorted by name, and show valid
regions for each name.

If that's not what you meant, perhaps you can give an example of what
you're trying to do.

mcmanusb wrote:
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.


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html