Finding duplicates

  • Thread starter Thread starter milkbonemom
  • Start date Start date
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?
 
=IF(AND(B2=B1,C2=C1),"dup","")

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


--


Regards,


Peo Sjoblom
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Delete rows takes forever 4
processing time (revised and re-posted) 10
Concatenat help, thanks 2
Deleting Duplicates 5
optimize cycle's speed -> For, Next or DO, UNTIL; IF-THEN, ENDIF or CASE, ENDCASE 1
Finding Duplicates in Multiple Columns 2
Transpose, but how? 0
Finding Duplicate Rows (Macro) 2

Back
Top