I’d like to detect where a value reaches a threshold within a range of cells. When the threshold is reached, I want to read a cell above.
My table contains a %age that grows up to 100%. I’d like to find when it reaches 70% and read the cell just above the >70% value.
Couldn’t find any smart function to do this…