Now ROW.COLUMN_RANGE function added to get relative column range:
Step 1: First, you need to create a calculated row using the 'Insert Rows' option in the Insert panel.
Step 2: After creating a calculated row and inserting a formula in the Formula Panel, the COLUMN_RANGE function will use a relative column range.
In the example below, the formula returns the maximum value from columns one to four, as shown in the second screenshot.
Frequently Asked Questions:Â
Does ROW.COLUMN_RANGE need to be wrapped with a function like MAX, MIN, or SUM?
Yes, the ROW.COLUMN_RANGE function needs to be wrapped with an aggregation function such as MAX, MIN, or SUM
