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]

"CP" wrote
> 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
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

[Kevin M]

Hey CP, another way:

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

HTH,
Kevin M

"CP" wrote:

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