I'd like a function script that compares the strings from two cells,
and returns, in a third cell, the parts of the 2nd string that do not
match parts of the 1st string (I don't need to return the parts of 1st
string that do not match parts of the 2nd string).

Examples:
Cell1: Chris
Cell2: Carl,Chris,Peter
Result in Cell3: Carl,Peter

Cell1: Chris,Carl
Cell2: Carl,Peter,Chris
Result in Cell3: Peter

Cell1: Chris,Dave
Cell2: Carl,Chris,Peter
Result: Carl,Peter

Cell1: Chris,Dave,Peter,Carl
Cell2: Dave,Chris,Carl
Cell3 is empty

Note, parts of the strings (separated by commas) will not necessarily
be in the same order.

Any help would be most appreciated

Thanks.

-- 
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Reply via email to