How do I find duplicate entries in Excel

C

cher

I have a list of over 900 names coressponding to other data, but need to know
if there are duplicate names on the list. What should I do?
 
B

bj

if it is in Column a you could add a new column B and enter in B1
=if(Countif(A:A,A1)>1,"**","")
and copy down to the bottom of your list
 
Top