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?
Hi,
In A1, we have the text quot;acdirquot; (without quotes) and in B1 we have the text
quot;acdirtyuquot; (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(quot;1:quot;amp;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
quot;Kelli Freemanquot; wrote:
gt; In Excel XP I'm trying to compare two columns and extract the differences in
gt; the 3rd column. For example,
gt;
gt; Column 1 Column 2 Column 3
gt; ACD ACDI I
gt;
gt; Is it possible to perform this function?
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: www.excelforum.com/member.php...oamp;userid=29948
View this thread: www.excelforum.com/showthread...hreadid=496531
- Feb 22 Thu 2007 20:35
How do I compare 2 text columns amp; show differences in 3rd?
close
全站熱搜
留言列表
發表留言