Dragging Formulas

  • Thread starter Thread starter Dave
  • Start date Start date
D

Dave

I'm trying to pull data from one sheet that exists in
every third cell, and place it into another sheet in
consecutive cells. Of course, once my initial cell
reference is made and I drag across the page, the cells
reference connsecutively. Is there a way to drag these
references across and reference every third cell (such as
H, K, N, Q, etc).

Dave
 
With your data in A1, D1, G1, J1 etc on sheet 2, the following pasted into cell
A1 on Sheet1 and copied across will put all the entries together consecutively:-

=OFFSET(Sheet2!$A$1,,(COLUMN()-1)*3)

With your data in B1, E1, H1, K1 etc on sheet 2, the following pasted into cell
A1 on Sheet1 and copied across will put all the entries together consecutively:-

=OFFSET(Sheet2!$A$1,,((COLUMN()-1)*3)+1)
 
Back
Top