Requirement:
1. Cell must accept values 0,00 and 1 to 99
2. Check for duplicates.
I set a range for all the above mentioned values. Set the format to Text so that it accepts 00 as well.
In the field i set data validation rule as =AND(COUNTIF($V$1:$V$101,F12), COUNTIF(F12:F23,F12)=1) to check for duplicates and value range.
$V$1:$V$101 - contains values 0,00 and 1 to 99
F12:F23 - set of 12 cells where i need to enter the valid values and check for duplicates.
When i enter values in the fields. it does not allow me to enter 0 in another cell if 00 is already entered and vice versa.
Please help me out.
Bookmarks