Hi,

I wanted to have a drop-down list using data validation that would let you
add extra options by entering them. In a previous post I found this solution:

Debra Dalgleish explains dynamic range names he
http://contextures.com/xlNames01.html#Dynamic

However, there is one problem. It now displays duplicates in the drop down
list. Is there any way to use this drop down list and a dynamic name range
but exclude duplicates from the list?

Thanks in advance!

Josh