Apr 07 2020 07:40 AM
Hi I am trying to create a formula on excel where if I drag down this would happen. e.g. cell B1 =A2-A1 then in cell B2 = A4-A3 and then in B3 = A6-A4 etc thank you
Apr 07 2020 08:05 AM
Since you gave us an image to work with, I'll give you one back. I think what you're looking for can be managed by the INDIRECT function. Here's some of the Help text on that function....and it's a fun one to play with. You can write a formula within your formula that increments the cell reference, as you're tring to do. Come back if you're not able to make it work in your situation.
Apr 07 2020 11:00 AM