2 DATA VALIDATION AT SAME CELL

[XLFanatico]

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]

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

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

 

[XLFanatico]

I guess no double DV allow, but this tecnique is very good
THANKS. Debra