Forum Discussion

rs2020's avatar
rs2020
Copper Contributor
Apr 06, 2018
Solved

Excel

Hi! I've got a problem in Excel. I need to make Tab A into Tab B in 3 or 5 clicks.   Tab A March 5 - 100 March 4 - 200 March 3 - 200 March 2 - 50 March 1 - 100   Tab B March 1 - 100 ...
excel
  • Haytham Amairah's avatar
    Haytham Amairah
    Apr 06, 2018

    Hi,

     

    Supposing that the Tab A is in range A1:A5, you can start this formula in any other cell and drag it down:

    =OFFSET($A$1,COUNTA(A:A)-ROW(A1),0)

    After that, you can get rid of the formulas by copying them then paste them as values only.

     

    Hope that helps

    Haytham

Haytham Amairah's avatar
Haytham Amairah
Silver Contributor
Apr 06, 2018

Hi,

 

Supposing that the Tab A is in range A1:A5, you can start this formula in any other cell and drag it down:

=OFFSET($A$1,COUNTA(A:A)-ROW(A1),0)

After that, you can get rid of the formulas by copying them then paste them as values only.

 

Hope that helps

Haytham

Resources