Matching Data Separated by Columns

[MadeInHB]

I am trying to match to find phone numbers that do not match within one field.  Below is an example with 4 potential phone numbers.  However there could be 2, 3 and more than 4 as well.  Is there a formula or something that can compare everything between commas and return a Yes/No match field?

[fmvizcaino · Accepted solution]

Hi @MadeInHB ,

I would suggest you to start from here. 

Best,

Fernando Vizcaino

[Simha]

Hello, You can do something like this. This returns -1 for true and 0 for false. Moreover, it gives you the first valid phone number from the list as well.