Duplicates
Hi!
Thanks everyone, the simple formula from Max, works perfect for me.
Regards
Dias
Max escreveu:
You could select B1
or select col B (if you want it applied similarly for the entire col)
then Click Data Validation
Allow Custom
Formula: =COUNTIF(A:A,B1)<1
Click Ok
Test it out
|