Forum Discussion
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...
The dynamic MAX formula in B3 is:
=MAX(INDEX(2:2,2+13*INT(COLUMN()/14)):
INDEX(2:2,COLUMN()))
The foregoing formula is then copied across, skipping the sum column (in bold format), as partly shown below:
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?