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.
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.