In order to calculate the MAX of a range, I'm attempting to develop an excel formula. References are recognized by the default formula as the limits of the admissible range of arguments:
=MAX(A1:A10)
By entering them in specific cells, I want to make the range's boundaries into variables, like:
=MAX(A"number of row taken from the content of cell B2":B"number of row taken from the content of cell B3)
See the attached screenshot.
Is this format supported by Excel? If yes, what's the correct syntax? Thank you!
