View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JLatham JLatham is offline
external usenet poster
 
Posts: 3,365
Default Offset every # of Rows

You could use something like this in I800 :
=OFFSET(I$63,(ROW()-ROW($I$800))*16,0)
and fill it down the sheet.

In row 800, that formula would return 0 for the middle value (rows to offset
from I$63)
in row 801 it would return 16, which would return the value 16 rows below
I$63 (at I79)
in row 802 it would return 32, which would return the value 32 rows below
I$63 (at I95)
"Javier Diaz" wrote:

Hello everyone, this is something I could just say = A1 then A=17 then A so
and so. But why, when I could use an offset formula, but jeezz louise, I
cant get it to work. I need a formula in I800to look at I63 bring back the
data, then on I801 to bring back I79 then on I802 to bring back I95. How can
I do this guys and gals.