Thread: Complex
View Single Post
  #1   Report Post  
kendallw4 kendallw4 is offline
Junior Member
 
Posts: 1
Default Complex formula to find max value of range based on multiple variable

Need help with a formula to find the max value of a range that is determined by a signal in column J that creates a lookback 2 values in 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 corresponding value in col I. I have attached an annotated sample that will hopefully better map out what I'm trying to do.
Attached Files
File Type: zip Sample 3.zip (17.6 KB, 41 views)

Last edited by kendallw4 : June 5th 12 at 06:42 PM