Count Distinct formula in multiple dropdown column

Corentin Dal Farra

Hello everyone

Do you know how I can use count distinct formula to a column that have multiple value dropdown list ? I think that it works only if I have one value per cell, but If I get multiple values for a cell then the count distinct formula do not work anymore.

I have the same question for a count distinct formula about multiple contact list column.

Thank you for your help, have a nice day,

Corentin

Leibel S

Corentin,

Run the below formula (changing the column name to match yours) in another Multi Select column. This will pull every unique value:

=JOIN([Column3]:[Column3], CHAR(10))

You can then run =COUNTM() on the cell where you put the previous formula.

Leibel S

Contact columns will require a bit more. Those are separated by "," not a char(10).

You would need to convert the contact column into a multi select column. Create a Multi Select column and your formula should be:

=SUBSTITUTE(CONTACT@row, ",", CHAR(10))

Then run the previous formulas on this column:

=JOIN([contactmulti]:[contactmulti], CHAR(10))

=COUNTM()

Corentin Dal Farra

Hello @Leibel S

It works perfectly, thank you for the tip !

Have a great day,

Corentin

FuryFerrell

When I use the countm(distinct()) formula, I get an answer of 4 instead of 3. There are no extra spaces in my cells. The formula is unable to see that the "K-S-212" in each cell is the same. How can I go about fixing this?