 # Referencing The Value In A Cell For A Max Equation

• Hi

I have a cell on 'Sheet 2' with the following formula:

=MAX('Sheet1'!C3:'Sheet1'C10)

ie. it chooses the maximum value from column C between rows 3 and 10 on "Sheet 1".

Lets say the cell reference [COLOR="Blue"]C10 [/COLOR]is now entered into cell [COLOR="Blue"]B1[/COLOR] on Sheet 2. How do I modify the above formula to reference [COLOR="Blue"]B1[/COLOR]?

I have tried INDIRECT function but can't get it to work.

Many thanks
Johno

• Referening The Value In A Cell For A Max Equation

Dear johno359,
--------------
I don't understand you....
If you want to modify your formula, you can type direct in formula bar.

• Re: Referencing The Value In A Cell For A Max Equation

Johno, I don't think you can do that. You are trying to get the maximum value for a range. You need to put the whole range in B1:

Sheet1!C3:C10

Then you can use:

=MAX(INDIRECT(B1))

• Re: Referencing The Value In A Cell For A Max Equation

Of course!

Couldn't see it! Thanks so much

Johno • Re: Referencing The Value In A Cell For A Max Equation

You're very welcome. • Re: Referencing The Value In A Cell For A Max Equation

VNExcel, Welcome to the forum! ## Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!