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     www.energyefficientbuild.com.   May 18, 2013
user freyj  (http://productforums.google.com/forum/#!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 ...

2 comments:

  1. Per your email (and I'll post in Google as well) the course names from the ClassRosters Tab should be pulled from the FromForm tab (all Unique names that were chosen). I don't have an easy way to export all possible names. My form is closed, so only classes listed on FromForm are possible class names.

    ReplyDelete
  2. Hi Joel: The spreadsheet associated with my response to your first questiobn is acting up, so I have presented a solution in my following blog post

    yogi_CrossTab EMail Address For Each Session In Sheet Named StudentSchedule2
    http://yogi--anand-consulting.blogspot.com/2013/05/yogicrosstab-email-address-for-each.html

    check it out and let me know how it goes.

    Make It A Great One
    Cheers!
    Yogi
    Cloud Computing -- Google Docs Way
    yogi--anand-consulting.blogspot.com


    ReplyDelete