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

[Peo Sjoblom]

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

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


--


Regards,


Peo Sjoblom



"milkbonemom" wrote in message
...
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?

[David Biddulph[_2_]]

&
--
David Biddulph

"milkbonemom" wrote in message
...
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?