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    www.energyefficientbuild.com

user cgraffius said: (http://productforums.google.com/forum/?zx=k0b6vmf3deg6#!category-topic/docs/spreadsheets/njaVeLNIgu8)
Spreadsheet to aggregate specific data
Hello-

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!

Courtney

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

-----------------------------------------------------------------------------------

following is a solution to a bit more generalized problem