How to count a specific letter in a column?

#1

There is a column where a string of letters like “S,S,L,L,M,M” to specify sizes. How can I count in this string, how many S and other sizes? I tried getting it be a linked record, but it summarizes itself to be S, M and L - ignoring the duplicates. Therefore, I cannot use the rollup function.

0 Likes

#2

You can use this technique:

1 Like