How to insert function every X number of lines

Copper Contributor

xyz456_0-1643115048551.png

 

I have a formula I'd like every 4 lines, i.e. D5 then D9 then D13. I have written it manually for D5 and D9 but when I highlight the rows from D5 to D9 and click the bottom right to extend the formula, it does not do what i expected. It instead goes D10 then D14/D15. Anyone know how I can do this? Thanks

1 Reply

@xyz456 

=IF(MOD(ROW(B5),4)=1,IF(AND(C4=1,OR(C3=3,C2=3)),C5,""),"")

 

Maybe with this formula if i correctly understand what you want to do.