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