ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Complex (https://www.excelbanter.com/excel-worksheet-functions/446238-complex.html)

kendallw4

Complex formula to find max value of range based on multiple variable
 
1 Attachment(s)
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.


All times are GMT +1. The time now is 06:36 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com