Debra - Thanks for the response. I don't think Autofilter would work
for this application. I didn't specify on my original post but the
original data with the multiple names is different than the data that I
would like to reference in a drop down list. The original list has a
name and a certain number. The number associated with the names places
that name in a predetermined position in a chart (multiple positions
when there are multiple names). I'd like the people to select their
name from the drop down, which would key Conditional Formatting to
highlight each spot in the chart where that name appears.
This list is only 50 names or so long so it would not be so hard to
manually remove the duplicate names for the drop down reference but I
have encountered this problem with much larger data sets with no
solution. I was hoping to figure something out on this small scale that
I could apply in the future on a larger scale.