Let’s understand how we could paste excel formula in alternate rows.
We see multiple scenarios in which we have to drag the formula with a cell gap between them.
We will see how we can achieve the below goal by pasting formula in alternate cell.
Suppose we have a difference column which calculates the difference of the cell value and the value just below the cell with the formula in B2 is =A3-A2.
Step 1
Enter the formula =IF(MOD(ROW(),2),A2-A1,””) in the cell B2 and copy paste the formula in the entire range as shown below.
We could leverage this technique to manipulate every nth row by replacing 2 in the MOD formula with n.
Hope this helped.
