Google Spreadsheet Post #1435
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. Nov 24, 2013
question by BTGov (http://productforums.google.com/forum/?zx=1kdqdmp9bh1u#!mydiscussions/docs/hRjM2vxYXoY)
How to display all values in a column across multiple sheets
I have a google spreadsheet with several sheets that are all formatted identically. Each sheet has it owns name relative to different accounts that I am tracking. Each sheet has the same column headers, but I want to generate another sheet with a formula that returns all values in column j for all sheets in document while excluding the blank cells.
---
Here is the link
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. Nov 24, 2013
question by BTGov (http://productforums.google.com/forum/?zx=1kdqdmp9bh1u#!mydiscussions/docs/hRjM2vxYXoY)
How to display all values in a column across multiple sheets
I have a google spreadsheet with several sheets that are all formatted identically. Each sheet has it owns name relative to different accounts that I am tracking. Each sheet has the same column headers, but I want to generate another sheet with a formula that returns all values in column j for all sheets in document while excluding the blank cells.
---
Here is the link
https://docs.google.com/ spreadsheet/ccc?key= 0AhTmii4aC_ EcdDc2eFlNdWdIajhaaGFYYmdhdHFJ N2c&usp=sharing
I basically want to have a sheet that shows all data in columns (B through I) across all sheets from "First" to "Last" when there is a value in column I.
Let me know what you think.
--------------------------------------------------------------------------------------------
No comments:
Post a Comment