Setting up a list where an item can only be picked once in Excel

[Guest]

I'm trying to set up a spreadsheet and I have a list where I would like items
picked only once.
Once that item has been picked, is it possible for it not to reappear in the
list in all the remaining cells in the range?

 

[T. Valko]

You can use data validation to do this.

Suppose the range of interest is A1:A5
Select the range A1:A5
Goto the menu Data>Validation
Allow: Custom
Formula: =COUNTIF(A$1:A$5,A1)<2
OK out

Whenever you attempt to enter a duplicate value you'll get a popup error
message.

Biff

 

[Debra Dalgleish]

There are instructions here for hiding used items in a data validation list:

http://www.contextures.com/xlDataVal03.html