Insert Row Every Two Rows and Subtract the Difference

  • I have numerous lengthy excel sheets that contain rows that have paired data. Specifically, I need to subtract the first row from the one that follows (e.g., row 2-row 1; row 4-row3; etc.) and place the result into a new row below each pair. My data in each sheet appear as follows: (there is only a header, and no row names)


    Recording timestamp Project name Export date
    321891 Study1_ETM ########
    422505 Study1_ETM ########
    323343 Study1_ETM ########
    424174 Study1_ETM ########
    341087 Study1_ETM ########
    374273 Study1_ETM ########


    I am mainly interested in calculating the differences between row pairs in the first column shown, but everything that I try results in errors.

    Any help would be greatly appreciated!

    • Best Answer

    Try this

    We now have a reputation system in place. If my reply helped please "Like" the reply by clicking the "Like" icon at bottom right of my reply.

    Edited once, last by KjBox ().

  • colclar

    Selected a post as the best answer.
  • You're welcome

    We now have a reputation system in place. If my reply helped please "Like" the reply by clicking the "Like" icon at bottom right of my reply.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!