Comparing text fields

  • Thread starter Thread starter allout22
  • Start date Start date
A

allout22

I have in an excel spreadsheet two columns of texts not numbers.
I would like to compare row 1 column a with row 1 column b
and return an exception if the two text fields do not match .
I have approx 10,000 rows , so you can see my problem .
Any help is deeply appreciated .

Regards Mason
 
One way ..

Put in C1: =TRIM(A1)=TRIM(B1)
Copy down to C10000

Col C will return FALSE for exceptions, TRUE otherwise

You could then do a Data > Filter > Autofilter on col C thereafter (insert a
new row1 first, and enter a label in C1) to filter out FALSE

TRIM will improve robustness of the comparison via removing any extraneous
leading, trailing or in-between spaces which may be present (but not readily
visible) in the text in cols A and B
 
Thanks Max that worked like a charm. I appreciate your help .

Regards Mason
 
You must log in or register to reply here.

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

matching & combining data from seperate worksheets 2
Comparison of columns using Conditional Formatting 3
Large Data File Consolidation... 2
Find partial text and retrun value in corresponding column 3
Conditional Formatting on calculated text 3
Comparing two columns and return a third 3
Comparing two spreadsheets 2
How do I compare two columns and return a number count 2

Back
Top