Type | Name | Syntax | Description |
Array | ARRAY_CONSTRAIN | ARRAY_CONSTRAIN (input_range, num_rows, ... | Constrains an array result to a specified ... |
Array | BYCOL | BYCOL (array_or_range, LAMBDA) | Groups an array by columns by application ... |
Array | BYROW | BYROW (array_or_range, LAMBDA) | Groups an array by rows by application of ... |
Array | FLATTEN | FLATTEN (range1, [range2,...]) | Flattens all the values from one or more ... |
You can use indirect()
Use: indirect("string that evaluates to a reference")
example: =Indirect("A"&B2)
In your case, it would be (replace [column]
indirect("[column]"&ArrayFormula(MAX(FILTER(ROW(B:B);NOT(ISBLANK(B:B))))))
