View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Alan Beban Alan Beban is offline
external usenet poster
 
Posts: 200
Default Offset every # of Rows

Enter in Cell I800

=OFFSET(I$63,16*(ROW()-800),0)

and fill down.

Alan Beban

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.