Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I compare 2 text columns & show differences in 3rd?
In Excel XP I'm trying to compare two columns and extract the differences in
the 3rd column. For example, Column 1 Column 2 Column 3 ACD ACDI I Is it possible to perform this function? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I compare 2 text columns & show differences in 3rd?
Hi,
In A1, we have the text "acdir" (without quotes) and in B1 we have the text "acdirtyu" (without quotes). In cell C1 enter the following array formula (Ctrl+Shift+Enter) =IF(ISNUMBER(FIND(A1,B1)),MID(B1,COUNTA(MID($A$1,R OW(INDIRECT("1:"&LEN(A1))),1))+1,10)) Please check various combinations to see how it works. If you have any further queries, please feel free to contact me at . Regards, Ashish Mathur "Kelli Freeman" wrote: In Excel XP I'm trying to compare two columns and extract the differences in the 3rd column. For example, Column 1 Column 2 Column 3 ACD ACDI I Is it possible to perform this function? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I compare 2 text columns & show differences in 3rd?
not that i know of. What is the purpose of doing that? There may be a way to format the text so that it can be manipulated, but depends on the purpose. For example: if the difference is always at the end of the data string, there would be an easy solution, especially if the data strings are all the same length. -- darkwood ------------------------------------------------------------------------ darkwood's Profile: http://www.excelforum.com/member.php...o&userid=29948 View this thread: http://www.excelforum.com/showthread...hreadid=496531 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
comparing columns of text (cross-searching) | Excel Discussion (Misc queries) | |||
Justify text across multiple columns | Excel Discussion (Misc queries) | |||
convert text labels to excel columns | New Users to Excel | |||
UDF and Calculation tree | Links and Linking in Excel | |||
Filtering Text Data from Multiple columns | Excel Worksheet Functions |