Excel: Add drop down list in cell

I found instructions on how to do this but I want to take it a step further. I havent been able to find how to do this or not sure what to search for. In the drop down box after I make a selection I would like that choice to disappear from the drop down. So that way I dont select the same option twice. This would help out greatly when creating the order of my lists. Is there a way I can do this?

This question generated 26 answers. To proceed to the answers, click here.

This thread is current as of September 11, 2014.

For more resources for Microsoft Excel