Hello,
I have a problem : I Need to compare each caracter into a column A with each caracter of the column B :
Example :
Can you help me please ?
Best Regards,
Bruno
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
It's perfect thank you !!
Have a good day!!
Kind regards,
