Hi,
I have a cell reference that displays a data table
='Base Data'!U4:AJ5
The data table in U4 to AJ5 is dynamic (but always ends in row 5) so was wondering if I can somehow offset the "AJ5" part of the formula. I want the "AJ5" part to change based on the last nonzero value in the row.
Thanks in advance!
I have a cell reference that displays a data table
='Base Data'!U4:AJ5
The data table in U4 to AJ5 is dynamic (but always ends in row 5) so was wondering if I can somehow offset the "AJ5" part of the formula. I want the "AJ5" part to change based on the last nonzero value in the row.
Thanks in advance!
Last edited: