I did a custom data validation for unique values.
This is my formula used:
=countif(C3:E5,C3)=1
However, it does not work.
Please advise.Thanks.
I did a custom data validation for unique values.
This is my formula used:
=countif(C3:E5,C3)=1
However, it does not work.
Please advise.Thanks.
this may be the right oneOriginally Posted by aijihz
=countif($C$3:$E$5,C3)=1
starguy
Tahir Aziz
PAKISTAN
https://www.facebook.com/businessexcel
__________________
Forum Rules (read before you post)
Links to the world of Excel
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks