You can use the technique shown here to create a list that hides the
previously used items:

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

XLFanatico wrote:
I have cells with data validation in column A set to range like this:
DV list =item
"item"will be the list that will drop down.
I don't want to repeat this items and have this formula:
=COUNTIF(A:A,A9)=1
Is there any way to add it together in the same cell as DV?
THANKS.


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