Check If String Column Contains A Value Greater Than a Number

[andreahq]

I want to check if a Column contains a value equal or greater than the value in another column. The thing is that the number of values separated by a "," in the second column might change.

Sample data:

Input

A	B
1	1,2
2	3,4,5
3	1,2

Output:

Output

Y

Y

N

[fmvizcaino · Accepted solution]

Hi @andreahq ,

You can use the following set of tools to accomplish that. Text to columns tool to separate the delimited values and the formula + summarize tool to identify is there is any higher value.

Best,

Fernando V.

[andreahq]

Thank you, this is a way simpler solution than I expected.