Check If String Column Contains A Value Greater Than a Number

Question

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

AB11,223,4,531,2

Output:

OutputYYN

fmvizcaino · Accepted Answer

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.