# Getting all the elements from an array that have the same value

**URL:** https://community.glideapps.com/t/getting-all-the-elements-from-an-array-that-have-the-same-value/59400
**Category:** Ask for Help
**Created:** [March 20, 2023, 11:57am UTC](https://community.glideapps.com/t/getting-all-the-elements-from-an-array-that-have-the-same-value/59400 "2023-03-20T11:57:23Z")
**Posts on this page:** 2
**Page:** 1

<div class="post-metadata">

### Author: ![bigansh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/bigansh/32/55910_2.png) [@bigansh](https://community.glideapps.com/u/bigansh)
#### Post date: [March 20, 2023, 11:57am UTC](https://community.glideapps.com/t/getting-all-the-elements-from-an-array-that-have-the-same-value/59400/1 "2023-03-20T11:57:23Z")

</div>

hey, i am not able to solve for something.

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/b/eb9661c808e3c8610b4e4b5deda3538efeffd787.png)  
the image you are seeing above, i want to create specific columns like 1-vs-1, pool of 5, etc., based on the array in leagues played. leagues played is a lookup column based on the bets relation column. please help.

---

<div class="post-metadata">

### Author: ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [March 21, 2023, 12:33am UTC](https://community.glideapps.com/t/getting-all-the-elements-from-an-array-that-have-the-same-value/59400/2 "2023-03-21T00:33:57Z")

</div>

So you want a unique array?

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/e/dec10e8b6de6add2b570d8e67104c267c9ee8f46.png)

Try this “Unique Elements” column on your array, and then use a “Joined List” column to join the text together for display purposes, if you need to do so.