Identifying all unique values for a Column, then counting number of rows with that value
I googled around for a while, but haven't seen this scenario (maybe I just missed it). I have data on a Master Sheet. A subset of that data is on the Backlog Sorting Report.
I want to somehow see a list of all of the values for a certain column and then a total number of rows that match that value. I don't want to write a formula for each possible column value because those values may change.
Once I have this automated list of each value plus the number count for that value, I want that to be included in a chart on a dashboard. Ideally, I would be able to click on a chart field and go back to the Backlog Sorting Report, but now filtered to that Topic. (I don't want much, I know....)
Even if someone could direct me to a help article for individual pieces, that would be very helpful. I've seen things on getting the number count, but not on generating the rows for each new value
Help Article Resources
Check out the Formula Handbook template!