Saturday, May 18, 2013

yogi_Pull From Sheet Named FromForm For Each Unique EMail Address Latest Submitted Sessions

                                          Google Spreadsheet   Post  #1197
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI   May 18, 2013
user freyj  (!category-topic/docs/documents/how-do-i/desktop/Iy8OkzKNBF0)

Create a class roster from Google form results
I'm trying to do several things within the shared spreadsheet below. Please help if you can!

  1. I need a list of the courses each email address has signed up for in each column of the below spreadsheet. Place holders in tab "studentschedule" have been made in the sheet for the layout (going into another form to run FormEmailer).
  2. I need to ensure only the last entry from the form is counted (some folks submitted more than one form)
  3. I need to also create a list of email addresses that will be in each class (tab named "class rosters").
I feel like it's a simple combination of three formulas, but my head's about to explode after trying to tweek TRIM, UNIQUE, INDEX, and TRANSPOSE for three days.

Can anyone help me?
here we go ...