Forum Discussion

morryp's avatar
morryp
Copper Contributor
Nov 21, 2019

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...
excel
Twifoo's avatar
Twifoo
Silver Contributor
Nov 21, 2019
In that case, lock the “Required” row. In MY SAMPLE (because you didn’t attach any), modify 2:2 to $2:$2.
morryp's avatar
morryp
Copper Contributor
Nov 22, 2019

Hi Twifoo 

 

Perfection!. Thank you so much for your solution. I greatly appreciate it.

Best regards

  • Twifoo's avatar
    Twifoo
    Silver Contributor
    Nov 23, 2019
    You’re perfectly welcome!

Resources