Paste Formula In Every Alternate/Nth Row In Excel

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.

Capture




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.

Capture

Capture




We could leverage this technique to manipulate every nth row by replacing 2 in the MOD formula with n.

Hope this helped.

Share The Knowledge

Random Posts

Leave a Reply