Using the results of the ADDRESS formula in another formula
 

Using the ADDRESS formula, cell B1 evaluates to A10.
Using the ADDRESS formula, cell B2 evaluates to A20.
I am trying to enter the MAX formula in cell C1 that uses the addresses
contained in B1 and B2
so that you have, in effect,
=MAX(A10:A20)

Thank you in advance.

Using the results of the ADDRESS formula in another formula
 

Got it. Just use the INDIRECT function.
Thanks anyway and best regards.

"JP" wrote:

Using the ADDRESS formula, cell B1 evaluates to A10.
Using the ADDRESS formula, cell B2 evaluates to A20.
I am trying to enter the MAX formula in cell C1 that uses the addresses
contained in B1 and B2
so that you have, in effect,
=MAX(A10:A20)

Thank you in advance.

Using the results of the ADDRESS formula in another formula
 

Try this:

=MAX(INDIRECT(B1&":"&B2))

--
Biff
Microsoft Excel MVP


"JP" wrote in message
...
Using the ADDRESS formula, cell B1 evaluates to A10.
Using the ADDRESS formula, cell B2 evaluates to A20.
I am trying to enter the MAX formula in cell C1 that uses the addresses
contained in B1 and B2
so that you have, in effect,
=MAX(A10:A20)

Thank you in advance.

Using the results of the ADDRESS formula in another formula
 

Biff, that's it. Thanks very much,
JP

"T. Valko" wrote:

Try this:

=MAX(INDIRECT(B1&":"&B2))

--
Biff
Microsoft Excel MVP


"JP" wrote in message
...
Using the ADDRESS formula, cell B1 evaluates to A10.
Using the ADDRESS formula, cell B2 evaluates to A20.
I am trying to enter the MAX formula in cell C1 that uses the addresses
contained in B1 and B2
so that you have, in effect,
=MAX(A10:A20)

Thank you in advance.

Using the results of the ADDRESS formula in another formula
 

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"JP" wrote in message
...
Biff, that's it. Thanks very much,
JP

"T. Valko" wrote:

Try this:

=MAX(INDIRECT(B1&":"&B2))

--
Biff
Microsoft Excel MVP


"JP" wrote in message
...
Using the ADDRESS formula, cell B1 evaluates to A10.
Using the ADDRESS formula, cell B2 evaluates to A20.
I am trying to enter the MAX formula in cell C1 that uses the addresses
contained in B1 and B2
so that you have, in effect,
=MAX(A10:A20)

Thank you in advance.