Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 --- |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to combine several columns into a single column | Excel Discussion (Misc queries) | |||
Hiding columns and custom views problem | Excel Discussion (Misc queries) | |||
Removing Near-Duplicate Rows, Leaving Those w/Most Data in Specific Columns | Excel Discussion (Misc queries) | |||
add a column to a pivot table that would show the difference between 2 other Columns | Excel Worksheet Functions | |||
Counting the Contents of Two Columns | Excel Discussion (Misc queries) |