Compare values in a single column seperated by a comma

[Shivi2110]

In a single column i have up to 7 values which are seperated by a comma. Is there any way i can identify if there is any different value in them. Below ex column 1 is a change and column 2 is not a change.

Example

                Column 1.    Column 2

Row 1.    A, a, b, x          A,a,a,a,a

[Shivi2110]

Thanks @Dan

[Shivi2110]

Hi, coming back on the above workflows, Is there a formula where i can see if any of the output columns contains "Change". And highlight those columns.

Thanks in advance!

[atcodedog05]

Hi @Shivi2110 

You can use table tool and setup column rule like below.

Output:

Learn more on table formatting in the below link.

https://community.alteryx.com/t5/Interactive-Lessons/Building-Tables/ta-p/553696

Hope this helps : )