Changing range of max() formula based on a cell contents

[Mr_Phil]

Hi, I am trying to change a max() formula on the fly.

If I put 8 in a cell the max formula would have one range to check and return.
If I put 10 in that cell the max formula would change range.

I attached a sample.

Heh. I thought this would be easy. But, Short of an eleven or twelve level If statement... I don't wanna do that.

Thank you for looking.

[Jonmo1]

Try

=MAX(OFFSET(L3,0,0,1,-O$15))

[Mr_Phil]

Try

=MAX(OFFSET(L3,0,0,1,-O$15))

My Friend! That worked just right. I have no idea what it means though. I will have to look it up and learn to parse it so I can explain it, but it works just what I needed. Thank you so much.

[Jonmo1]

You’re welcome

The syntax of offset is

OFFSET(range,#ofrows,#ofcolumns,height,width)

Maybe that will help