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))

Participate now!

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