Hi all,
I have a small issue with extracting a MAX value from a row of cells that depend on the range of a different row when it exceeds a certain value.
I attached a simplified example of my problem. It contains a Time series in seconds (row 2) and 2 subjects (row 3,4). I need the max value of row 3 (and row 4, separately), but the range depends on when the time (row 2) exceeds a certain value (value of column H).
I hope I provided enough information, please let me know if anything is unclear. I appreciate any help.
Cheers,
Sam
Bookmarks