Matching two Cells

[mmmarks]

Hi Friends,

Hopefully It will done by VBA UDF here is scenario...
Eg :1
In Cell A1 , I have ... "This is Monday "
In Cell B1, I have .. " This is Tuesday "

I need in C1, Tuesday.. ( as I need to get word(s) which are unmatch with A1 and Its not fixed length of sentence)

Eg 2 : A1, Hi How are you
B1, Hi How am I
Result in C1, am I


Thanks in advance..

 

[schielrn]

This UDF should do it for you?

Function missing(rng1 As Range, rng2 As Range) As String
Dim arr1() As String
Dim arr2() As String
Dim storage As String
arr1 = Split(rng1.Value, " ")
arr2 = Split(rng2.Value, " ")
For Each a In arr2
    If IsError(Application.Match(a, arr1, 0)) Then
        storage = storage & a & " "
    End If
Next a
missing = Trim(storage)
End Function

Excel Workbook
	A	B
1	This is Monday	Hi How are you
2	This is Tuesday	Hi How am I
3	Tuesday	am I
Sheet1

Cell Formulas
Range	Formula
A3	=missing(A1,A2)
B3	=missing(B1,B2)

Hope that helps.

 

[mmmarks]

Thanks a ton Workss great!!!