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
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
No comments:
Post a Comment