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

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?

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

You can use data validation to do this.

Suppose the range of interest is A1:A5
Select the range A1:A5
Goto the menu DataValidation
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

"J." wrote in message
...
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?

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

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

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



J. wrote:
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?


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html