2 DATA VALIDATION AT SAME CELL
 

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.

2 DATA VALIDATION AT SAME CELL
 

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

2 DATA VALIDATION AT SAME CELL
 

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

"Debra Dalgleish" wrote:

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