No duplicate names in a range (A2:A200)

J

JorgeAE

I am preparing a spreadsheet in which I have to input names from
A2:A200. Each name must be different. I would like to know if there is
a function that automatically prevent me to duplicate a name in that
column range. Thank you for your support.
 
B

Biff

Hi!

You can use data validation to do this.

Select the range A2:A200
Goto Data>Validation
Allow: Custom
Formula: =COUNTIF(A$2:A$200,A2)<2
OK

Biff
 
Top