Friday, February 3, 2012

yogi_Group The Entities In A Column By Specified Categories And Present The Breakdown Graphically

Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                  

use annetteit said:
i've done a questionnaire and i have a column with the age of all the people that have answered this questionnaire.
i would like to group the ages of the people in 3 categories ranging from 20 - 35, 36-50 , 50+
how can google docs sort the column with the ages of people into these 3 categories so i know how many people there are in each categories and can see it graphically?
following is a solution to the problem