Offset every 27th row in a column that is 2 cells wide (merged cel

  • Thread starter Thread starter KS
  • Start date Start date
K

KS

I am trying to move values from one worksheet to another using the OFFSET
function. The worksheet I am pulling from has data on every 27th row and the
cells are 2 columns wide (the cells are merged i.e. A1:B1).

This is the formula I used: =OFFSET('Elem Bnchmrk'!$B$17:$C$17,ROW()*27-1,0)

Please help!
 
Try this instead in the starting cell:
=OFFSET('Elem Bnchmrk'!$A$17,ROWS($1:1)*27-27,)
Copy down
 
Hi

One way
=INDEX('Elem Benchmark'!$A:$A,(ROW(A1)-1)*27)
Copy down as far as required
 
Thank you for your help! I finally got it to work. I've been reading help
files and these discussion groups for a couple of days trying to get it to
work!
 
Back
Top