View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Harlan Grove[_2_] Harlan Grove[_2_] is offline
external usenet poster
 
Posts: 1,231
Default Offset every # of Rows

"Javier Diaz" wrote...
....
. . . 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.

....

If you mean I800 and subsequent cells would evaluate to the values of every
16th cell beginning with I63, here's an alternative.

I800:
=INDEX($I$63:$I$262,16*ROWS(I$800:I800)-15)

Fill down as needed.