# How to segregate No. of individual items at lookup array?

**URL:** <https://community.glideapps.com/t/how-to-segregate-no-of-individual-items-at-lookup-array/41564>\
**Category:** Ask for Help\
**Created:** [May 3, 2022, 12:06am UTC](https://community.glideapps.com/t/how-to-segregate-no-of-individual-items-at-lookup-array/41564 "2022-05-03T00:06:16Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![Hani\_Ibrahim](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/hani_ibrahim/32/42108_2.png) [@Hani\_Ibrahim](https://community.glideapps.com/u/Hani_Ibrahim)\
**Post date:** [May 3, 2022, 12:06am UTC](https://community.glideapps.com/t/how-to-segregate-no-of-individual-items-at-lookup-array/41564/1 "2022-05-03T00:06:16Z")

</div>

i have a look up array values as shown in the photo, Kindly, how can i segregate the count of each item,

How many “A”, How many “S”, How many “E” etc.

it tried : if-then-else, but the available conditions are:  
“is empty”, “is not empty”.  
i couldn’t find “is” only.

![Glide segregate](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/8/28caf1b2e3ff3dd7090bca9097a8a80c21982443.jpeg)

---

<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:** [May 3, 2022, 12:14am UTC](https://community.glideapps.com/t/how-to-segregate-no-of-individual-items-at-lookup-array/41564/2 "2022-05-03T00:14:59Z")

</div>

How do you want it to be displayed?

Should it be “A: 2, S: 1” and “A: 1” for your 2 examples?

---

<div class="post-metadata">

**Author:** ![Hani\_Ibrahim](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/hani_ibrahim/32/42108_2.png) [@Hani\_Ibrahim](https://community.glideapps.com/u/Hani_Ibrahim)\
**Post date:** [May 3, 2022, 12:24am UTC](https://community.glideapps.com/t/how-to-segregate-no-of-individual-items-at-lookup-array/41564/4 "2022-05-03T00:24:29Z")

</div>

i really want to count the A and S etc  
as you respectively stated, Then i want to use a rollup column to show that count, so i can use it with the serial numbering for each A, and S

---

<div class="post-metadata">

**Author:** ![gvalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gvalero/32/1037_2.png) [@gvalero](https://community.glideapps.com/u/gvalero)\
**Post date:** [May 3, 2022, 12:31am UTC](https://community.glideapps.com/t/how-to-segregate-no-of-individual-items-at-lookup-array/41564/5 "2022-05-03T00:31:39Z")

</div>

Hola,

Something like this can help you [🔢 Count duplicate elements in an array or list](https://community.glideapps.com/t/count-duplicate-elements-in-an-array-or-list/41313)

Saludos!

---

<div class="post-metadata">

**Author:** ![Hani\_Ibrahim](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/hani_ibrahim/32/42108_2.png) [@Hani\_Ibrahim](https://community.glideapps.com/u/Hani_Ibrahim)\
**Post date:** [May 3, 2022, 12:42am UTC](https://community.glideapps.com/t/how-to-segregate-no-of-individual-items-at-lookup-array/41564/6 "2022-05-03T00:42:11Z")

</div>

i will give a try, and study 😅 where should i post that code.

Thank you so much

---

<div class="post-metadata">

**Author:** ![Hani\_Ibrahim](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/hani_ibrahim/32/42108_2.png) [@Hani\_Ibrahim](https://community.glideapps.com/u/Hani_Ibrahim)\
**Post date:** [May 3, 2022, 2:07am UTC](https://community.glideapps.com/t/how-to-segregate-no-of-individual-items-at-lookup-array/41564/7 "2022-05-03T02:07:45Z")

</div>

to be Honest, i couldn’t figure out how to use this code, i found where i should past and adjust accordingly, but with no luck for success, i am not a coder at all.

However, i found one way around by dedicating each choice to certain category and do the lookup based on that. it worked.

Really appreciate your continues support to new Glider like me.

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\
**Post date:** [May 4, 2022, 2:08am UTC](https://community.glideapps.com/t/how-to-segregate-no-of-individual-items-at-lookup-array/41564/8 "2022-05-04T02:08:23Z")

</div>

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.