Monday, December 12, 2011

yogi_Query Form Responses Sheet To Extract Records Considering Time Of Submittal

Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                            www.energyefficientbuild.com
user MF_Elm said:
How would I then modify this:
=ArrayFormula(query(
ImportRange("spreadsheet1_key","Sheet2!A:I"),"select Col2,Col3,Col4,Col5,Col6 where Col9=1"))
to first filter only those entries that are less than 24 hours, and then again (on a separate sheet) those entries that are older than 24 hours while still checking for the 1 in col9?
Thanks again.
---------------------------
following is a solution to the problem

No comments:

Post a Comment