Forum Discussion
Counting Unique Values Across Multiple Columns
Hello, I am trying to count unique values across multiple columns. I am exporting student activities from my work database. You can see from my example how the database exports this information. ...
OliviaBurglund As a variant, perhaps you want to consider PowerQuery. Connect to the table with activities, flatten it with "unpivot" and group (count) by activity. Just a few clicks. No complicated formulae needed. See attached.