I'm in a tricky situation..
I've been trying to minimize creating multiple parallel columns of IF(MAX) condtions and was wondering if there was a way to simply scan rightwards (X->Y->Z) and move on to the next row (i.e. in excel A7->B7->C7-> A6->B6->C6 -> A5->B5->C5).
(please see excel sheet)
Essentially, the trigger will start a continuos sequence in which
-it checks if the next value is at least 98% or bigger than the previous one. If it is, then the process continues to the next Cell.
**Also, if it's bigger then the last one, then it becomes the New Highest value in which all next values will be compared to.
-Although, if it's lower then 2% of the value compared to, then it reports back that value in a subsequent column..
Thanks a lot for your help
Bookmarks