Thursday, September 19, 2013

yogi_Pull Values From Responses Sheet For A Given Row And Column And Then Drag Down To Pull Values From Every Second Successive Column In The Corresponding Row

                                          Google Spreadsheet   Post  #1373
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/spreadsheet/ccc?key=0AoiOHFjFsZRfdGlONzFhYTlObU9YZFJUTkJCb2pIenc&usp=sharing

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.

-----------------------------------------------------------------------------------------------------------------------------------------------------