How do I compare 2 text columns & show differences in 3rd?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Kelli Freeman - 28 Dec 2005 22:09 GMT

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?

Reply to this Message

Ashish Mathur - 29 Dec 2005 00:38 GMT

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,ROW(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 mathurashish@hotmail.com.

Regards,

Ashish Mathur

> In Excel XP I'm trying to compare two columns and extract the differences in
> the 3rd column. For example,
[quoted text clipped - 3 lines]
>
> Is it possible to perform this function?

Reply to this Message

darkwood - 29 Dec 2005 00:42 GMT

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.

Signature

darkwood

Reply to this Message