Thread: I've borrowed this formula for finding duplicates
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Steved Steved is offline
external usenet poster
  
Posts: 519
Default I've borrowed this formula for finding duplicates
Hello from Steved

My objective is to search Columns A:A and C:C for duplicates if found then
in Column G:G put yes.

=IF(COUNTIF(A423:C423,"DUPLICATE"),"yes")

Thankyou.
Reply With QuoteReply With Quote