How can I get the list in B1 based on data available in A1 to A10. In A1 to A10 data may be duplicate but in the list I should get the unique values.
A1:A10
kiran
naveen
ram
uma
ram
ravi
naveen
raju
kiran
lalith
B1 drop down list should come as below
kiran
naveen
ram
uma
ravi...