Danny - this was asked earlier today and the answer was to log onto
http://www.cpearson.com/excel/duplicat.htm - this gives you the forumual for
testing for duplicated entries
Hope this helps
Sam

"Danny" wrote:

Hi,

Column B of my workbook contains names (more than 500 rows). How do I find
(macro or worksheet function) if a name has been entered more than once.

Thank you.