Hi
I'm trying to prevent duplicates from being entered into any cell in multiple columns and across any row, the formulas I've been trying haven't worked. This is what I'm using, is there anyway to do this? thanks for thelp
=COUNTIFS($B$2:$B$6000,$B2,$D$2:$D$6000,$D2,$F$2:$F$6000,$F2)<=1
I'm trying to prevent duplicates from being entered into any cell in multiple columns and across any row, the formulas I've been trying haven't worked. This is what I'm using, is there anyway to do this? thanks for thelp
=COUNTIFS($B$2:$B$6000,$B2,$D$2:$D$6000,$D2,$F$2:$F$6000,$F2)<=1