Forum Discussion
Jump over a row when dragging down a formula
Hi, I am trying to put in a formula in excel. The problem is that every 7th row I have a row that I don't want to compute but instead jump to the next row but I still want to have the result ben...
Hi Carl,
Could you please clarify a bit
- in your sample you don't compute 4th row, it shall be 7th one instead?
- what is your formula if compute? For row 2 that's B2/B3, for row 5 - B5/C5
- what shall be in row 1?
- if not compute you take result from previous row?