Help with Offset formula

K

Ken G.

I have two worksheets. The first worksheet has data in every 4th column ie a,
d, g, j, etc that I want to bring in to columns a,b,c,d etc on the second
sheet.

Using the offset function I either need to move the reference cell each time
or move the offset itself. How can I do this?
 
D

Domenic

Assuming that Sheet1!A1:Z1 contains the data, try...

A1, copied across:

=INDEX('Sheet1'!$A1:$Z1,COLUMNS($A1:A1)*3-3+1)

Adjust the sheet reference and range for your data accordingly.

Hope this helps!
 
K

Ken G.

Thanks - I was on the wrong track completely!

Domenic said:
Assuming that Sheet1!A1:Z1 contains the data, try...

A1, copied across:

=INDEX('Sheet1'!$A1:$Z1,COLUMNS($A1:A1)*3-3+1)

Adjust the sheet reference and range for your data accordingly.

Hope this helps!
Click to expand...
 
Top