Compare character to character and put results in different column

[bulletshiva]

Hello,

I have a need to compare 2 columns and put the result in the third column.

The critical part here is to compare letter to letter. so unable to find a logic to do this.

Request your help

The data is as below:

[TABLE="width: 342"]
<colgroup><col span="2"><col></colgroup><tbody>[TR]
[TD]Column1[/TD]
[TD]Column2[/TD]
[TD]Result[/TD]
[/TR]
[TR]
[TD]KCVEDPAFLSQBGXZ[/TD]
[TD]KCDPLSQXZ[/TD]
[TD]VEAFBG
[/TD]
[/TR]
</tbody>[/TABLE]

 

[Rick Rothstein]

And here is another User Defined Function that should also work...

Function Missing(Col2 As String) As String
  Dim X As Long, Dept As String
  Missing = "KCVEDPAFLSQBGXZ"
  For X = 1 To Len(Col2)
    Missing = Replace(Missing, Mid(Col2, X, 1), "")
  Next
End Function

 

[bulletshiva]

Great! Thanks it works

is there also a way to send automatic e-mail ? example alphabet C is in column B, then send mail to "example@gmail.com". i have a contact responsible for each of the characters "
KCVEDPAFLSQBGXZ". i will have to assign person responsible for each "alphabet" and send mail as per column B. sorry for not putting this need

 

[Peter_SSs]

Great! Thanks it works

Good to hear.

is there also a way to send automatic e-mail ? example alphabet C is in column B, then send mail to "example@gmail.com". i have a contact responsible for each of the characters "
KCVEDPAFLSQBGXZ". i will have to assign person responsible for each "alphabet" and send mail as per column B. sorry for not putting this need

Yes there is, but that is not an area of strength of mine. Somebody else may step in to help or you can have a look around at Ron de Bruin's website where I have seen many people referred to for that sort of thing.

 

[bulletshiva]

I don't find any match Peter, any suggestions from your side

 

[Peter_SSs]

I don't find any match Peter, any suggestions from your side

I have no idea what you are referring to.

 

[bulletshiva]

ok, let me google to find the fix. thanks again

 

[Peter_SSs]

ok, let me google to find the fix.

Find the fix to what? How does this relate to this thread?