# Column Similarity
**URL:** https://community.glideapps.com/t/column-similarity/59159
**Category:** Ask for Help
**Created:** [March 14, 2023, 8:37pm UTC](https://community.glideapps.com/t/column-similarity/59159 "2023-03-14T20:37:53Z")
**Posts on this page:** 9
**Page:** 1
### Author:  [@ibrahim17](https://community.glideapps.com/u/ibrahim17)
#### Post date: [March 14, 2023, 8:37pm UTC](https://community.glideapps.com/t/column-similarity/59159/1 "2023-03-14T20:37:53Z")
Hi, everyone, I am confronting a problem regarding if then else column. The First column is the user column where he selects the teams through choice component. The second column is a joined list column, extracted from another sheet, where admin also has choice component and he selects the teams. If both the user and admin column matches then there is congrats message.
The problem comes when the teams selection is not aligned in same manner in both user and admin column then if then else column doesn’t shows the message that I want.
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [March 14, 2023, 9:05pm UTC](https://community.glideapps.com/t/column-similarity/59159/2 "2023-03-14T21:05:14Z")
Replace the Admin Joined List column with a Lookup column. Then create a Split Text column to convert the user list to an array. Now you will have two arrays. Next create two Sort Array columns to sort all of the values in each array. Finally create two Joined List columns to merge both sorted arrays into comma delimited text strings. Then your IF column can properly do a comparison.
---
### Author:  [@ibrahim17](https://community.glideapps.com/u/ibrahim17)
#### Post date: [March 14, 2023, 9:28pm UTC](https://community.glideapps.com/t/column-similarity/59159/3 "2023-03-14T21:28:09Z")
Thank you for the explanation, but If you can please share an example I will be thankful to you
---
### Author:  [@ibrahim17](https://community.glideapps.com/u/ibrahim17)
#### Post date: [March 15, 2023, 11:01am UTC](https://community.glideapps.com/t/column-similarity/59159/4 "2023-03-15T11:01:10Z")
> [@Jeff\_Hager](#):
>
> comma delimited test strings
Can you explain. What does it mean?
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [March 16, 2023, 12:59am UTC](https://community.glideapps.com/t/column-similarity/59159/5 "2023-03-16T00:59:38Z")
Not sure why there’s a “test” word there, it should be just comma-delimited strings, as results of the Joined List column.
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [March 16, 2023, 3:23am UTC](https://community.glideapps.com/t/column-similarity/59159/6 "2023-03-16T03:23:22Z")
@ibrahim17 @ThinhDinh Sorry about that. I fixed the post. That’s what happens when I type out these responses on my phone. I tend to fat finger my words.
@ibrahim17 Were you able to get it to work? Sorry, I haven’t had a chance to get to my computer to grab some screenshots. Been busy the past couple of days.
---
### Author:  [@ibrahim17](https://community.glideapps.com/u/ibrahim17)
#### Post date: [March 17, 2023, 12:26am UTC](https://community.glideapps.com/t/column-similarity/59159/7 "2023-03-17T00:26:53Z")
Yes, thanks a lot, Jeff your idea worked, but I am still not clear about comma\_delimited strings?
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [March 17, 2023, 1:04am UTC](https://community.glideapps.com/t/column-similarity/59159/8 "2023-03-17T01:04:37Z")
A comma delimited text string is just a list of items with a comma between each item. The comma is the delimiter. For example (apple,orange,banana,pear).
---
### Author:  [@system](https://community.glideapps.com/u/system)
#### Post date: [March 18, 2023, 1:05am UTC](https://community.glideapps.com/t/column-similarity/59159/9 "2023-03-18T01:05:18Z")
This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.