Difference between 2 columns
 

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

Difference between 2 columns
 

"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
---

Difference between 2 columns
 

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