Hi,
I have a 3 column dataset. Column A has the data point names, Column B has class names for each data point. Column C has sub-class names for each data point. Every class has its own unique set of sub-classes. I would like to know the number of sub-classes for each class.
Put more succinctly, I’d like to count every unique value in column C for every unique value in column B.
In the example, I have a list of 11 students who have classes in Sports and Music categories. In sports there are Football, and Basketball sub-classes. In Music, Guitar, Piano, and Drums… The numbers I want to find is 2 for Sports and 3 for Music.
In the real data all relevant values are in string format. There are over 20k data points, 11 classes and over 200 sub-classes.
I know that I can make lists for classes and sub-classes and use countifs, but this is impractical as, sadly, there is no straightforward way of filtering unique values in a column in LO calc.
I tried to do it with pivot tables but couldn’t, I’m not very competent with them. May be an array formula would work but I don’t know how to use them well either.
Thanks a lot in advance and have a very nice day!
(LO v.25.2.4.3)
ask_lo_sample_count_unique_class.ods (16.1 KB)