View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
milkbonemom milkbonemom is offline
external usenet poster
 
Posts: 3
Default Finding duplicates

I'm trying to find if the row in column B and C matches the row aboe and if
so put dupl in the cell in column A.
=IF(B2andC2=B1andC1,"dupl","")
The information in each column is text so I didn't use +. Any suggestions?