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.
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
Something like this can help you 🔢 Count duplicate elements in an array or list
i will give a try, and study 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 appreciate your continues support to new Glider like me.
This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.