Compute number of occurrences in a column of a spreadsheet
Posted
by
wnstnsmth
on Super User
See other posts from Super User
or by wnstnsmth
Published on 2012-12-14T09:23:36Z
Indexed on
2012/12/14
11:08 UTC
Read the original article
Hit count: 200
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
... ....
Please note, I only want to look for whole words, and not part words. EG, the words 'on' and 'one' appears in the word 'money' - I would not count this (eg, only the word money is counted).
Hope that is clear enough. What formula should I use?
© Super User or respective owner
