Tuesday, February 28, 2012

yogi_Count The Number Of Specified Entities Laid Out In Indefinite Number Of Columns In A Sheet

Yogi Anand, D.Eng, P.E.                Google Spreadsheet          Post  #448          www.energyefficientbuild.com

user JohnT1979 said:
Counting occurences of a words on a spreadsheet
On one tab I have a series of rows and colums that have a bunch of names of different companies. A lot of them are duplicated throughout the sheet. Here is an example: https://docs.google.com/spreadsheet/ccc?key=0At9MZ6gkPp_EdFEydk52aGNqaU1vRnhXY0FVaXBWenc#gid=0
What I'd like to do on a separate tab fina way to automatically list each Company and how many times it appears. Is there a way to automatically populate that list with the number of occurences so it would look like:
Company A 4
Company B 2
Company C 1
Is there a formula or two I can use to do this?
Any insight would be greatly appreciated.
following is a solution to the problem -- the number of companies are listed in columns of Sheet1 ... and the count of the companies is computed in Sheet2