Monday, March 26, 2012

yogi_Tabulate Name And Number Of Times A Name Has Been Entered In A Column

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

user orlando said:
Count repetitions
I have a spreadsheet which displays a series of names (James, John, George, etc.), and I need to know how many times are they appearing (repetitions) on the colum.
How can I do a check on a colum and present on a separate cell information on how many times is each name repeated (appears), such as:
Example->
James:  3
John:   4
George: 2
etc.
thanks
 ---------------------------------------------
following is a solution to the problem