Well done Seti ! Appreciate your knowledge & Help in this forum.... On Fri, Apr 8, 2011 at 1:23 PM, SHC <stuart.hallcoo...@googlemail.com>wrote:
> Thanks STDEV(i) - very appreciated. > > > On Apr 8, 6:29 am, "STDEV(i)" <setiyowati.d...@gmail.com> wrote: > > *=TextDif(A2,B2)* > > > > TextDif is an UDF, like this: > > > > Function TextDif(S1 As String, S2 As String) As String > > Dim Arr1, Arr2 > > Dim n As Integer, i As Integer, t As String > > > > Arr1 = Split(S1, ","): Arr2 = Split(S2, ",") > > > > For i = LBound(Arr2) To UBound(Arr2) > > For n = LBound(Arr1) To UBound(Arr1) > > If Arr1(n) = Arr2(i) Then Arr2(i) = "" > > Next n > > Next i > > > > For i = LBound(Arr2) To UBound(Arr2) > > If Len(Arr2(i)) > 0 Then t = t & Arr2(i) & "," > > Next i > > > > TextDif = t > > If Len(t) > 0 Then TextDif = Left(t, Len(t) - 1) > > End Function > > > > On Fri, Apr 8, 2011 at 4:46 AM, SHC <stuart.hallcoo...@googlemail.com > >wrote: > > > > > > > > > > > > > > > > > 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. > > > > > > > > ctv_TextDif about Chris and Peter.xls > > 29KViewDownload > > -- > > ---------------------------------------------------------------------------------- > 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 > -- ---------------------------------------------------------------------------------- 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
