Offset help!

  • Thread starter Thread starter mx-3 for me
  • Start date Start date
M

mx-3 for me

If I am trying to fill a column that I want its reference to incremen
every 24th row, what is the format of Offset that I am supposed t
use?
I realize I asked a question like this earlier but this Offset thin
confuses me:confused:
I have
=Sheet1!B6
I want to fill that for 24 rows and then have it say =Sheet1!B7 th
next set of 24, and so on.
Your help is so much appreciated! :)

Michell
 
No OFFSET here, but you could use this in row 1:

=INDIRECT("Sheet1!B"&SUMPRODUCT(--(MOD(ROW(INDIRECT
("1:"&ROW())),24)=1))+5)

HTH
Jason
Atlanta, GA
 
Thanks all, after playing around with my formula I finally got it.

FYI I used:

=OFFSET(Sheet1!H$6,((ROW(C3)-ROW(C$3))/24),0)

But thanks- this forum is great help
 
Back
Top