Compute number of occurrences in a column of a spreadsheet
- by wnstnsmth
I have a Google Drive spreadsheet with a single column that holds string values (Twitter screen names) such as "user1", "user1", "UserX", and I would like to count those values so that I can easily craft a bar chart out of it. So the result should be
value occurrence
-----------------------
user1 2
UserX 1
... ....
…