Hello -
I have a horizontal line chart that contains numerous high and low points (with time and date stamps). I am trying to write a formula (or find a function) that would calculate the distances between each high and low point for each of the drops (sometimes numerous ups and downs per day). Basically, these are tank level measurements and I am trying to calculate the totals of just the "drops." Does anyone have any advice re: how this might be accomplished? I may also need to include some logic where only drops < or > a certain amount are included in the drop totals. Can anyone help with this? Thanks!
I have a horizontal line chart that contains numerous high and low points (with time and date stamps). I am trying to write a formula (or find a function) that would calculate the distances between each high and low point for each of the drops (sometimes numerous ups and downs per day). Basically, these are tank level measurements and I am trying to calculate the totals of just the "drops." Does anyone have any advice re: how this might be accomplished? I may also need to include some logic where only drops < or > a certain amount are included in the drop totals. Can anyone help with this? Thanks!
