software

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.
www.cpearson.com/excel/NoDupEntry.htm
at Chip Pearson's site

--
Regards,
Tom Ogilvy

quot;JorgeAEquot; gt; wrote in message
...
gt;
gt; I am preparing a spreadsheet in which I have to input names from
gt; A2:A200. Each name must be different. I would like to know if there is
gt; a function that automatically prevent me to duplicate a name in that
gt; column range. Thank you for your support.
gt;
gt;
gt; --
gt; JorgeAE
Hi!

You can use data validation to do this.

Select the range A2:A200
Goto Datagt;Validation
Allow: Custom
Formula: =COUNTIF(A$2:A$200,A2)lt;2
OK

Biff

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