Lists in Excel

[ncortez]

Hi,

I am attempting to create a list in excel. However, my list has various entries that are the same. I want to make it so that the drop down list menu will only list each of the entries once, regardless of whether they are in the data more than once. However, I want it to show all the entries that match that data. Please let me know if someone knows how to do this and can help.

Thank you

 

[Andrew Poulsom]

Welcome to MrExcel.

Can't you just use AutoFilter?

 

[nicekev500]

Are you talking about data validation.. if you want a drop down list?