Forum Discussion
How to insert function every X number of lines
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
=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.
