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