Google Spreadsheet Post #2246
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI Sep-21-2017
comment by Mrugesh Patel; question by: mrdanpratt
http://productforums.google.com/forum/?zx=lkth9hlcc6om#!category-topic/docs/spreadsheets/o_Y9Nuesggw
Filter form responses to show only the most recent response if data is duplicated
Let's say I want people to fill out a form with their email address and their favorite color (just for example). So the spreadsheet (the sheet name is 'Form Responses') has column A with the timestamp, column B with the email address and column C with the color. Let's say I want to display this data on a second sheet using =ARRAYFORMULA('Form Responses'!A:C)
Let's say someone responds with red but later they want to change their response to blue. So they respond again. I don't want to display both of their choices. I only want to display all the most recent ones on the second sheet. Is there a way to create such a filter? It would be fine to display the filtered data further to the right on the second sheet, like in columns D, E, and F. Any help would be appreciated.
-------------------------------------------------------------------------------------
Let's say I want people to fill out a form with their email address and their favorite color (just for example). So the spreadsheet (the sheet name is 'Form Responses') has column A with the timestamp, column B with the email address and column C with the color. Let's say I want to display this data on a second sheet using =ARRAYFORMULA('Form Responses'!A:C)
Let's say someone responds with red but later they want to change their response to blue. So they respond again. I don't want to display both of their choices. I only want to display all the most recent ones on the second sheet. Is there a way to create such a filter? It would be fine to display the filtered data further to the right on the second sheet, like in columns D, E, and F. Any help would be appreciated.
-------------------------------------------------------------------------------------
No comments:
Post a Comment