how to compare text fields in 2 different columns in excel

M

mickbarry

Thought I'd dust the cobwebs off this one as it seems to be very old.
Suppose text1 is in A1 and text2 is in A2 .
Then =a1=a2 should do the trick.
If the data is the same then "True" will be displayed.
If the data is different then "False" will be displayed.

Regards Mick Barry
You know that you are getting old,
when you finally reach the top of the ladder,
and find it leaning against the wrong wall
 
G

Govind

Hi,

If the Text data needs to be matched exactly including the Uppercase or
lowercase, then use

=EXACT(A1,A2)

This will return true, when text in A1 and A2 are exact match.

If you dont want to do an exact match including case, then use

=IF(A1=A2,"TRUE","FALSE")

Regards

Govind.
 

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

Comparing fields in an excel worksheet 1
compare info in 4 worksheets and highlight fields that are the sam 3
Excel Comparing two columns 1
View 2 workbooks to compare 1
OR Exact statement not working to compare values in two columns 4
compare 5 columns of text and highlight duplicates based on repeti 2
Compare two columns 2
Compare 2 sets of data 7

Top