Let's say in cell A1 the value is "$E$1"
Let's say I want to calculate the max value of E1:E10
Normally, I'd use: =MAX($E$1:E10)
But for my purposes, I want the formula to read the text entered in A1 to set the start of the range:
=Max((read value from A1):E10)
I am trying to figure out how to 'read' the value of A1 into the range criterion so it will still give me the correct range reference, the only difference is for the start of the range it is reading the value in A1 to set it
Let's say I want to calculate the max value of E1:E10
Normally, I'd use: =MAX($E$1:E10)
But for my purposes, I want the formula to read the text entered in A1 to set the start of the range:
=Max((read value from A1):E10)
I am trying to figure out how to 'read' the value of A1 into the range criterion so it will still give me the correct range reference, the only difference is for the start of the range it is reading the value in A1 to set it
Last edited: