Saturday, February 1, 2014

yogi_Find Only Most Recent Entries Per Person From Form Responses

                                         Google Spreadsheet   Post  #1512
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI   Feb-01-2014
question by Res Net (!category-topic/docs/spreadsheets/VKmchxjJFGI) 
Finding only most recent values per person for form responses
I am working on a player roster for my Ingress community.  I have an initial sign up form where players input necessary data and I have a different form where players can update some of their info.  My issue is that I only want to use the data from the last update the person submits but I cant seem to figure out how to do it.

My sample data is their name, zone they play in, would they like to be included in the roster, and are they over 18?  I use that info via a vlookup to update their main listing in the roster or, exclude them from it altogether if they choose to opt out or are not 18. (have to protect the young ones and ourselves these days).

The ideal solution would automatically fill as the form is used and more responses pop up on the sheet much like the =continue() that follows arrays such as =filter().  

Any help would be appreciated.