I am trying to find how to prevent duplicates in data validation in Excel 2013. I am sure that there used to be a tick box called 'Prevent Duplicates' or similar but am blowed if I can find it now.
Any help acknowledged and appreciated.
Replies (5)
Please login or register to join the discussion.
this is my data validation for entry in cell F1
in the data validation selection select Custom
in the formula field enter something like
=IF(COUNTIF(F:F,F1)>1,FALSE,TRUE)
select OK
in column F I entered
a,b,c,d,e,f
in the following cell I entered 'a' again and the entry was refused