Compare cell text to set list and show text differences

[NSTurk725]

Hello. I need help solving the following issue. I am trying to write a function that will compare the text of cell "A2" to the text of cell "B2" and display cell "A2"'s text characters that didnt match from cell "B2" in column C. Can anyone help me out with writing this formula?

EX:

A2 = "Apple123"
B2 = "AppleS78"

Result = "S78"


Thank you in advance.

[jrdnoland]

Wouldn't your result be 123; those are the characters that are in A2 and not in B2.

Or do you just want to remove from B2 the characters that are the same in A2?

Can it be vba code? You could write something to pull one character at a time from A2, compare it against B2 and save it to another variable if it doesn't match.

[pike]

hi jrdnoland
Are there any patterns in the strings
A2 = "Apple123"
B2 = "AppleS78"
Result = "S78"
what if
A2 = "Apple127"
B2 = "AppleS78"
would the result be "S8" ?
or
A2 = "Appl127"
B2 = "AppleS78
would the result be "eS8" ?
playing around with

Please Login or Register  to view this content.

when I realised that the next step comparing the two arrays with a Dictionary would remove all duplicates
can you please illuminate/clarify any patterns/requirements

[pike]

try this udf..

Please Login or Register  to view this content.

[jrdnoland]

hi jrdnoland
Are there any patterns in the strings
A2 = "Apple123"
B2 = "AppleS78"
Result = "S78"
what if
A2 = "Apple127"
B2 = "AppleS78"
would the result be "S8" ?
or
A2 = "Appl127"
B2 = "AppleS78
would the result be "eS8" ?
playing around with

Please Login or Register  to view this content.

when I realised that the next step comparing the two arrays with a Dictionary would remove all duplicates
can you please illuminate/clarify any patterns/requirements

Hi Pike - I had similar questions, like your function. Will have to see what the original poster wants.

[pike]

hi jrdnoland
this is the other logical option

Please Login or Register  to view this content.

up early as the fish are calling ciao

[NSTurk725]

Hey guys, sorry about that. First off, I appreciate your help. Secondly, you were right jr...the result should have been "123". My fault. Here is how the data will look:

Customer Part-Customer Part Number

A2 = "Alternator-DD123"
B2 = "Alternator-SF164"

C2 = DD123

Basically, I am trying to pinpoint the changes from month to month. Did the change result from a customer part or a customer part number.

I hope this information helps. Sorry again about the unclear and shitty first post.

[pike]

Hi NSTurk725
this function will do it

Please Login or Register  to view this content.

[NSTurk725]

Thank you Pike! I appreciate your help greatly.

[pike]

No worries is was fun