Forum Discussion
Need help with an OFFSET formula applying to a block of rows
Hello, I'm attempting to apply a formula to 4 cells in a column, then have it apply the same formula to 4 more cells nth rows below repeating. I've attempted to use OFFSET for this method, but I'...
Thank you for the clarification. Previous formula started from each 14th row. If skip 14 rows after each 4th like here
when
=INDEX(T:T,INT((ROW()-ROW($M$2)-1)/4)*18+MOD(ROW()-ROW($M$2)-1,4)+ROW($M$2)+1)If skip 13 rows, change 18 on 17 in the formula.
SergeiBaklan Thank you very much for your help.
Jacob_Afelskie , you are welcome