G Guest Jan 24, 2006 #1 Hi: Is there a simple formula to identify the difference between data in 2 fields? AAA AAA AAA AAB BBB BBB CCC CCD
Hi: Is there a simple formula to identify the difference between data in 2 fields? AAA AAA AAA AAB BBB BBB CCC CCD
M Max Jan 24, 2006 #2 Hi: Is there a simple formula to identify the difference between data in 2 fields? AAA AAA AAA AAB BBB BBB CCC CCD Click to expand... 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 ---
Hi: Is there a simple formula to identify the difference between data in 2 fields? AAA AAA AAA AAB BBB BBB CCC CCD Click to expand... 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 ---
