Formula to count of items in a multi dropdown list
The drop-down multi select is very nice and useful. I started to use it yesterday, but I need to use the formula =countif(range, criterion).
I want to count how many times a value is repeated in a range that has multi values. I use the formula countif and only count one time a repeated value when the cell have multiple values. I hope I explain well my point.
Luis from PR
Help Article Resources
Check out the Formula Handbook template!