Share via

If after writing in cell B1=A1, B2=A2, B3=A3,... and then I wanted to write B4=A2, B5=A3, B6=A4 and then B7=A3, B8=A4 ... and so on, How to do that ?

Anonymous
2019-01-17T21:42:37+00:00

If after writing in cell B1=A1, B2=A2, B3=A3,... and then I wanted to write B4=A2, B5=A3, B6=A4 and then B7=A3, B8=A4 ... and so on, How do I do that ?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
  1. HansV 462.6K Reputation points MVP Volunteer Moderator
    2019-01-17T22:51:57+00:00

    In B1:

    =INDEX($A:$A,INT((ROW()-1)/3)+MOD(ROW()-1,3)+1)

    Fill or copy down.

    1 person found this answer helpful.
    0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2019-02-21T06:49:11+00:00

    im trying to create a cell that shows me the difference of how much I spent each month.  so for instance in cell A1 I spent $100 in Jan. In A2 I spent $250 in Feb. $300 in march and so on.  what I want is a formula I can put in the blank cell at the bottom that will subtract A2 from A1. then A3 from A2, then A4 from A3 then when I input money spent for may it will subtract A5 from A4 and it will give me the difference in the blank cell at the bottom.  any help is greatly appreciated.   thanks

                A1

    JAN.    100

                A2

    FEB.     250

                A3

    MAR.   300

                A4

    APR.    400

               A5

    MAY

    BLANK CELL $

    0 comments