How to insert function every X number of lines

Occasional Visitor



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




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