Saturday, September 22, 2012

yogi_Make A Computed Column For Student Scores In Sheet1 And Extract ClassRoom Records By Teacher

Yogi Anand, D.Eng, P.E.      Google Spreadsheet   Post  #775  Sep 22, 2012

user cgraffius said: (!category-topic/docs/spreadsheets/njaVeLNIgu8)
Spreadsheet to aggregate specific data

I'd like to the data received from a form in a spreadsheet to aggregate specific information and view the summary of this. For example, each math teacher is filling out a form for each student. The math teacher provides her name in the form. I would like to sort so that only the data for that teacher is aggregated into a summary. Any tips or scripts for this? Thank you!


I'm using Google Chrome.
---- is the link...


following is a solution to a bit more generalized problem