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]

How do you want it to be displayed? Should it be “A: 2, S: 1” and “A: 1” for your 2 examples?

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

i will give a try, and study :sweat_smile: where should i post that code. Thank you so much

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 appr…

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

Ask for Help

gvalero May 3, 2022, 12:31am 5

Hola,

Something like this can help you 🔢 Count duplicate elements in an array or list

Saludos!

Topic		Replies	Views
Can i count the number of repeated items in array column Ask for Help	4	926	May 19, 2022
How do I count occurrences in an array column? Ask for Help	13	2657	October 30, 2022
Count Exact Word Similar in an array Ask for Help	6	526	September 18, 2022
Finding Duplicate Values in Lookup Arrays Ask for Help	1	810	June 3, 2021
🆕 Rollups, Single Values and JoinLists FROM ARRAYS! Community Resources	24	2182	August 13, 2021

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

Related topics