Google Spreadsheet Post #1373
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. Sep 19, 2013
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. Sep 19, 2013
user Greg B. Johnston (http://productforums.google.com/forum/?zx=x8ts4l41ygu7#!category-topic/docs/spreadsheets/iG9SJ8AMu7Y)
Pasting formula and choosing how many rows to increment?
Here's something like my data: https://docs.google.com/
The goal is to pull data from the 'Responses' sheet columns C/D, E/F, and G/H into the 'Results' sheet as I have it. The purpose is to have each organization's numbers in a separate row in the 'Responses' sheet, but the same row in the 'Results' sheet. The problem is that when I drag down or copy and paste the formula, it increments the row references by 3s, rather than by 1s.
I'll look at the solution you posted and see if I can figure it out.
-----------------------------------------------------------------------------------------------------------------------------------------------------
Pasting formula and choosing how many rows to increment?
Here's something like my data: https://docs.google.com/
The goal is to pull data from the 'Responses' sheet columns C/D, E/F, and G/H into the 'Results' sheet as I have it. The purpose is to have each organization's numbers in a separate row in the 'Responses' sheet, but the same row in the 'Results' sheet. The problem is that when I drag down or copy and paste the formula, it increments the row references by 3s, rather than by 1s.
I'll look at the solution you posted and see if I can figure it out.
-----------------------------------------------------------------------------------------------------------------------------------------------------
No comments:
Post a Comment