how to prevent duplicates in column with exception of number 0
I am creating a weighted score table. The data validation rule I would like to enforce on the column(which is user input) is no duplicate numbers in column allowed except for number 0.
I was able to restrict duplicates with data validation rule "=COUNTIF($E$15:$E$26,$E15)<=1" but how do I add 0 as exception to be repeatable but not other numbers?
Use OR condition...
So something like.
=OR(COUNTIF($E$15:$E$26,$E15)<=1,$E15=0)
?Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.?
― Robert A. Heinlein
It worked. You are amazing.
You are welcome
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks