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.