compare two columns in same worksheet for similarities
 

I'm trying to compare column A to column B for similarities. Would like
similarities entered into column C. Can this be done?

compare two columns in same worksheet for similarities
 

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.

"Cynthia" wrote in message
...
I'm trying to compare column A to column B for similarities. Would like
similarities entered into column C. Can this be done?

compare two columns in same worksheet for similarities
 

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.

"Fred Smith" wrote in message
...
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.

"Cynthia" wrote in message
...
I'm trying to compare column A to column B for similarities. Would like
similarities entered into column C. Can this be done?