How to count a specific letter in a column?


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.



You can use this technique:

1 Like