ExcelBanter - Finding duplicates

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Finding duplicates (https://www.excelbanter.com/excel-discussion-misc-queries/190029-finding-duplicates.html)

milkbonemom

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?

Peo Sjoblom

Finding duplicates

=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_]

Finding duplicates

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

All times are GMT +1. The time now is 02:36 PM.