Max Indirect Function

[lindasanter]

Hello,

I have the following function =MAX(INDIRECT”B1:F1”)). When I copy/drag this formula down, B1:F1 stay the same. I need it to change and become B2:F2, etc.

Thanks for you help!

[oeldere]

=MAX(INDIRECT”B1:F1”))

Does this (it) work for you?

Please show it in an excel file, without confidential information.

[Jonmo1]

Why not just
=MAX(B1:F1)

Why the use of Indirect?

[FDibbins]

Hi and welcome to the forum

maybe this?
=MAX(INDIRECT”B"&row(a1)&":F"&row(a1)))

[lindasanter]

I have included an attachment. That formula works, but doesn't work when I copy it down the column. The cell highlighted in yellow should be 6.

[lindasanter]

When we add columns to the spreadsheet the range changes.

[Jonmo1]

Try
=MAX(INDIRECT("B" &ROW()&":F"&ROW()))

[lindasanter]

I get an error when I try this formula.

[oeldere]

You can use the formulat of Jonmo1.

I tested the formula, and of course it works.

[lindasanter]

You are correct. It works. THANKS