Compare each caracters from two columns

[Brunoml]

Hello,

I have a problem : I Need to compare each caracter into a column A with each caracter of the column B :

Example : 

A	B	Result
1,2	1,2	OK
2,1	1,2	OK
1,3	1,2,3	OK
1,4	1,2,3	NOK

Can you help me please ?

Best Regards,

Bruno

[NicoleJohnson · Accepted solution]

Hi!

Try this formula for the Result column:

If ReplaceChar(ReplaceChar([A],",",""),ReplaceChar([B],",","||"),"")="" Then "OK" Else "NOK" Endif

What this will do is compare field A (without any commas) to field B (replacing any commas with the double-pipe || "OR" operator), and if a match is found in A for any of the characters in B, it will replace that character in A with a blank. If there is anything leftover after comparing to all the options in B, then the Result will be "NOK".

Does this accomplish what you're looking for? :)

NJ

[Brunoml]

Hello,

It's perfect thank you !! :)

Have a good day!!

Kind regards,

Bruno