# question is cross-posted in mrexcel forum #
https://www.mrexcel.com/board/thread...rence.1212573/

I need help with a couple of formulas based on information (cell range/reference) obtained from the cell above.

E2 identifies the number of consecutive days value increased (excluding 0s)
E4 need help with formula: from the identified range of consecutive days of increasing flow in col.B (result in E2), find the difference bet max and min values (you'll need to go one cell above the identified range to catch the starting point) - expected result in F4

E3 identifies the number of consecutive days value decreased (excluding 0s)
E5 need help with formula: from the identified range of consecutive days of decreasing flow in col.B (result in E3), find the difference bet max and min values (you'll need to go one cell above the identified range to catch the starting point) - expected result in F5

Please check link below for the dataset and spreadsheet info

https://www.mrexcel.com/board/thread...rence.1212573/

Thanks!!