Google Spreadsheet Post #1212
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. May 27, 2013
user Alistair Fraser (http://productforums.google.com/forum/?zx=twarxl97ddra#!mydiscussions/docs/e12jwAERI4o)
How to set up a sheet to display selected rows from another sheet?
We would like to set up a sheet to display a list of rows from another sheet, which contain dates within the range: from today for the next 28 days. These dates are in one of the columns of the source sheet. The display sheet will look the same are the source sheet but just show the rows within the date range.
---
Thanks Yogi
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. May 27, 2013
user Alistair Fraser (http://productforums.google.com/forum/?zx=twarxl97ddra#!mydiscussions/docs/e12jwAERI4o)
How to set up a sheet to display selected rows from another sheet?
We would like to set up a sheet to display a list of rows from another sheet, which contain dates within the range: from today for the next 28 days. These dates are in one of the columns of the source sheet. The display sheet will look the same are the source sheet but just show the rows within the date range.
---
Thanks Yogi
I've tried to work it out, I think it's a QUERY, but not sure ...
Here a link to a sheet I've done to explain what I'm trying to do
https://docs.google.com/ spreadsheet/ccc?key= 0Agk9K8AL3znNdG82NDZkUEUyRGxmU G9DUEJWWDg3Rmc&usp=sharing
Best Wishes
Alistair
------------------------------------------------------------------------------------------------------
No comments:
Post a Comment