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 t...
=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.