Difference between 2 columns

[CP]

Hi: Is there a simple formula to identify the difference between data in 2
fields?
AAA AAA
AAA AAB
BBB BBB
CCC CCD

 

[Max]

Hi: Is there a simple formula to identify the difference between data in 2
fields?
AAA AAA
AAA AAB
BBB BBB
CCC CCD

One guess ..

A quick way would be to flag out the differences, then use autofilter

Assuming data as posted is in cols A and B, from row2 down

Put a label in C1

Put in C2: =TRIM(A2)=TRIM(B2)
Copy C2 down

Then select C1, click Data > Filter > Autofilter

Choose FALSE from the autofilter droplist in C1

The filtered rows would be those where the data does
not match in cols A and B, thus requiring closer inspection

 

[Kevin M]

Hey CP, another way:

In C
=if(a1=b1,"Match"."No Match")

HTH,
Kevin M