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
etc
Is there a formula or two I can use to do this?
Any insight would be greatly appreciated.
Thanks!
-------------------------------------------------------
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
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
etc
Is there a formula or two I can use to do this?
Any insight would be greatly appreciated.
Thanks!
-------------------------------------------------------
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
No comments:
Post a Comment