Forum Discussion
morryp
Nov 21, 2019Copper Contributor
Keeping the higher value in a variable row
I have a challenge that seemed simple to me at the beginning. Famous last words. Hoping you can provide guidance. Some context before the question if that helps to frame it better. Context: A row i...
morryp
Nov 21, 2019Copper Contributor
Twifoo Thank you very much for the formula. It works beautifully when I test it on a blank sheet recreating the three rows and applying the formula in B3 as you explained.
When working on the live model I inserted a row below the variable numbered row and applied the formula. It would not return a value. Is the formula dependent on the row and cell?
Twifoo
Nov 21, 2019Silver Contributor
In that case, lock the “Required” row. In MY SAMPLE (because you didn’t attach any), modify 2:2 to $2:$2.