Forum Discussion
Solved
I Need help designing a LET() function properly.
My problem revolves around creating a range, using variables provided by the LET() function, to create a proper range for a MAX() function. The variables are row numbers. Background: I weigh mysel...
- Why don't you use Indirect function.
=Max(Indirect("Meter!D6:D"&RowIDnow)
=LET(number,COUNTA(Meter!D6:D1048576),result,MAX(INDIRECT("Meter!D6:D"&number+5)),result)An alternative with LET could be this formula which seems to work in my sheet.