compare two columns in same worksheet for similarities

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

Fred Smith

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.
 
R

rj

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.
 

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

Scrubbing two excel worksheets, returning unique values from one sheet 0
How To Compare Two Csv Files Mainly Two Columns Containing Time 0
Two columns followed by single page-width column on same page 0
Comparing 2 columns from 2 different Worksheet and Returing Value of a 3rd column 2
Sum Values from different column 1
Comparing two columns and returning value from another column 1
Is this possible? 0
comparing sheet to sheet and adding value 1

Top