Check digits between column

[iamrony]

Hi all
I have got 2 columns and 17 digits for each column and i want to check digit between 2 columns and then report different digit.m

Hope you help and Thank for help!

example

A | B | result digit differance
PE2ET77141SB02023 | PE2FT77141SB02023 | 5
MNBBS2D305W485838 | MNBBB2D305W485838 | 5
MNBBS2D304W375808 | MNBBS2D304W37588 | 16

[rylo]

Hi

1) Do you want to return the position of the different characters?
2) If so, then shouldn't the first result be 4 not 5?
3) In your example file, there are 3 items in column B that have 16 characters, not the 17 you stated.
4) What do you want to do if there is >1 differences? Comma separate the positions?

rylo

[Trebor76]

Hi iamrony,

Though your thread explanation / example and the data on your spreadsheet are not overly clear, I've created the following macro which if doesn't do the trick should go a long towards it:

Please Login or Register  to view this content.

[iamrony]

Trebor76,rylo : you are excellent! That it work! thanks for all the help!

[jindon]

UDF
Use in cell like
=If(iamrony(A1,B1)=0,"",iamrony(A1,B1))

Please Login or Register  to view this content.

[iamrony]

Thank you for your help