Staggered Row Subtraction

[ModernHW]

Hi,

I'm trying to figure out a formula that will be able to help me take subtractions off of staggered rows. I've attached examples of what I'm looking to accomplish. Rows 2-825 is a series of dates with specific data points. Columns A-C are data outputs.

Columns D-E is where I'd like to be able to plug a formula for the desired outputs shown on rows 16-33.

Not sure if anyone can help...
Column A Column B Column C Column D Column E
Date PivotHi PivotLo HitoLo LotoHi Formula
2001-05-18 0 0 Row3
2001-05-25 0 0 Row4
2001-06-01 0 0 Row5
2001-06-08 0 0 Row6
2001-06-15 0 0 Row7
2001-06-22 0 0 Row8
2001-06-29 0 0 Row9
2001-07-06 0 0 Row10
2001-07-13 0 0 Row11
2001-07-20 0 0 Row12
2001-07-27 0 0 Row13
2001-08-03 0 0 Row14
2001-08-10 0 0 Row15
2001-08-17 0 0 Row16
2001-08-24 0.1849 0 0.057 =B16-C20 Row17
2001-08-31 0 0 0.057 =D16 Row18
2001-09-07 0 0 0.057 =D16 Row19
2001-09-14 0 0 0.057 =D16 Row20
2001-09-21 0 0.1279 0.057 0.0435 =D16 =B28-C20Row21
2001-09-28 0 0 0.0435 =E20 Row22
2001-10-05 0 0 0.0435 =E20 Row23
2001-10-12 0 0 0.0435 =E20 Row24
2001-10-19 0 0 0.0435 =E20 Row25
2001-10-26 0 0 0.0435 =E20 Row26
2001-11-02 0 0 0.0435 =E20 Row27
2001-11-09 0 0 0.0435 =E20 Row28
2001-11-16 0.1714 0 0.0193 0.0435 =B28-C33=E20 Row29
2001-11-23 0 0 0.0193 =D28 Row30
2001-11-30 0 0 0.0193 =D28 Row31
2001-12-07 0 0 0.0193 =D28 Row32
2001-12-14 0 0 0.0193 =D28 Row33
2001-12-21 0 0.1521 0.0193 =D28 Row34

Thanks in advance.

Henry

 

[Joe4]

Welcome to the Board!

I don't know if your question is quite clear. Your sample really didn't turn out right, as everything is smashed together so you cannot tell what is in what cell.

You cannot upload files to this site. But there are tools you can use to post screen images. They are listed in Section B of this link here: http://www.mrexcel.com/forum/board-a...forum-use.html.
Also, there is a Test Here forum on this board that you can use to test out these tools to make sure they are working correctly before using them in your question.

You may want to try a better image and description of what it is exactly you are trying to accomplish.