I have a Google Sheet with a column of comma separated lists for example:
- atl hip hop, dirty south rap, hip hop
- atl hip hop, hip hop, rap
- canadian hip hop, canadian pop, hip hop
I need help creating a formula to count unique items across all the lists and order them by count. Thanks!
I found this from another post:
=ArrayFormula(QUERY(TRANSPOSE(SPLIT(JOIN(“,”,A:A),”,”)&{“”;””}),”select Col1, count(Col2) group by Col1 label count(Col2) ””,0))
It counts the unique items but I don’t know how to use “order by” to order the results by Col2.
pjgei is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.