Finding duplicates

M

milkbonemom

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?
 
P

Peo Sjoblom

=IF(AND(B2=B1,C2=C1),"dup","")

=IF(B2&C2=B1&C1,"dupl","")


--


Regards,


Peo Sjoblom
 
Top