Do Data - Filter - Advanced Filter and select unique values. HTH Otto
"Raj" wrote in message
...
How do I create a unique dropdown from a list of values in another column
most of which occur more than once

Thanks in advance