This reference's method works for me
Excel formula: Data validation unique values only

Allow = Custom
Make sure you are ignoring blanks
Try <2 instead of =1

__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia