No duplicate names in a range (A2:A200)
 

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.

No duplicate names in a range (A2:A200)
 

http://www.cpearson.com/excel/NoDupEntry.htm
at Chip Pearson's site

--
Regards,
Tom Ogilvy

"JorgeAE" wrote in message
...

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.


--
JorgeAE

No duplicate names in a range (A2:A200)
 

Hi!

You can use data validation to do this.

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

Biff

"JorgeAE" wrote in message
...

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.


--
JorgeAE