Cell Reference in max formula

[martijnrikkert]

Hello,

I need a formula where I have a simple max formula =MAX(B5:C5).

The point is the C5 should not be entered like this but is in a different cell. In the example the second cell reference is in cell A8:C5.

I put a small excel file in the attachement that will make things clear. Should not be so hard.

Thank in advance.

[Pete_UK]

You can use this formula:

=MAX(INDIRECT("B5:"&$A$8))

Hope this helps.

Pete

[martijnrikkert]

Thank you it works!

[Pete_UK]

Good to hear it, and thanks for the rep.

If that takes care of your original question, please take a moment to select Thread Tools from the menu above and to the right of your first post in this thread, and mark the thread as SOLVED.

Pete