K
kendallw4
Need help with a formula to find the max value of a range that i
determined by a signal in column J that creates a lookback 2 values i
Col F to set the range of column C where the max value is pulled from
The max value from the range is then subtracted from it's correspondin
value in col I. I have attached an annotated sample that will hopefull
better map out what I'm trying to do
+-------------------------------------------------------------------
|Filename: Sample 3.zip
|Download: http://www.excelbanter.com/attachment.php?attachmentid=401
+-------------------------------------------------------------------
determined by a signal in column J that creates a lookback 2 values i
Col F to set the range of column C where the max value is pulled from
The max value from the range is then subtracted from it's correspondin
value in col I. I have attached an annotated sample that will hopefull
better map out what I'm trying to do
+-------------------------------------------------------------------
|Filename: Sample 3.zip
|Download: http://www.excelbanter.com/attachment.php?attachmentid=401
+-------------------------------------------------------------------