Please clarify your question. Can you give an example?

"mcmanusb" wrote in message
...
I have three columns with repeated values in each that I am using to create
dependent drop down lists using data validation in excel.

Because of the repeated values in each column (not just the first one),
I'm
having trouble getting the drop down lists to display only pertinent
information. If there are three repeated values in the second/third
column,
the drop down will display three options, where there should just be one.
Can you help me qualify the validations to eliminate acknowledgement of
repeats?

Ms. Dalgleish's website is great and has been instrumental in getting this
far, and I know I'm close! I appreciate any help you can provide.