Trying to check for duplicates in multiple columns using data validation but its not functioning correctly.
Formula:
=CountIFS($A$2:$A$6000, A2,$B$2:$B$6000,B2,$C$2:$C$6000,C2)=1
When I try and enter unique data it gives error code I set up.
Formula:
=CountIFS($A$2:$A$6000, A2,$B$2:$B$6000,B2,$C$2:$C$6000,C2)=1
When I try and enter unique data it gives error code I set up.