View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
mcmanusb mcmanusb is offline
external usenet poster
 
Posts: 6
Default 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.