compare two columns in same worksheet for similarities

  • Thread starter Thread starter Cynthia
  • Start date Start date
C

Cynthia

I'm trying to compare column A to column B for similarities. Would like
similarities entered into column C. Can this be done?
 
What do you define as similarities? Equality is easy to determine, but
similar can be pretty nebulous. Give us some examples of what you want to
do.

Regards,
Fred.
 
You can use the Exact function =exact(text1,text2) in column C and drag the
formula down the column. If it's similar, it returns TRUE, if not it says
FALSE. You can then select the column, copy and "paste special" as values to
do a Find for true. Or you can use the IF function in column D to copy the
true values: =IF(C1=FALSE," ",B1). You can then copy and paste special as
values the entire column D and then delete column C.
 
Back
Top