Thread: Locate Duplicates
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
  
Posts: 3,718
Default Locate Duplicates
=IF(COUNTIF($A$1:A1,A1)1,"Duplicate","")


"Gary" wrote:

Hi,

I have a list of names in a column, i want to check if there are any names
repeated. What would be the best way to do it?

Thanks
Gary



Reply With QuoteReply With Quote