2 DATA VALIDATION AT SAME CELL

X

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top