How to count the # of multi selected items from a drop down selection?
I have a column that has 5 selections from a drop down, and allows for multi-selection. Is there a way to count the number of times 1 selection was made, 2 selections were made, 3 selections were made etc.?
I tried using CountM, but I was not able to get the formula to produce the expected results, if any. Any idea on how to do this?
Help Article Resources
Check out the Formula Handbook template!