Tuesday, January 26, 2016

yogi_Pull First Instance Of A Record From 'Form responses 1' Sheet If The Record Was Submitted Within The Specified Number Of Days of The Refrenced Date

Google Spreadsheet   Post  #2030
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jan-21-2016
post by: Ferdi T :
RE: I need help writing a non complicated formula/query
Hi there,
I'm really bad with google sheet and almost as bad with searching forums so I apologise if my problem already found an answer.

I have a very simple google spreadsheet (just 6 columns, where the first one "A" is the time stamp); the file is populated via google forms.

I was wondering if you could help me to write a formula (query/array formula or anything that is more appropriate) that allowed me to constantly extract from one sheet ('Form responses 1') to a new sheet, all the rows generated in a given period of time (i.e. all the rows generated in the last 30 or 40 days).

This second sheet would be publicly shared on the web and should only show the entries of the above mentioned period of time (i.e. the last 30 or 40 days).

It would also be super if the formula (or a different formula) eliminated any duplicate row (column B contains a 16 digit alphanumeric code that could be used as the reference term for duplicates).

Thank you very much for your help.