I have a Google sheet with 2 columns.
| Jim | Foo | | John | Bar | | Jane | X | | Jim | YZ |
What I usually do is:
- download the values as a CSV
- write/run a script that processes the CSV
- the script goes over each row, groups by the first column, and counts occurrences.
- Then I output the values in descending order by number of occurrences.
How can I do this directly in Google Sheets using a formula?
The ordering of ties does not matter, so the expected output would be:
| Jim | 2 | | John | 1 | | Jane | 1 |
| Jim | 2 | | Jane | 1 | | John | 1 |