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)
Not sure I understood the data layout. In any case it's better to use structured Tables not to define dynamic ranges.
Second, why don't simply use
=MAX(D:D)or you have other data after last row except texts and blank cells ?