#21 ·
I messed up right here:
=IF(COUNTA(A$1:A$1000)<ROWS(A$1:A1); ""; INDEX(A$1:A$1000;COUNTA(A1:A$1000)))
The formula was highlighting A1 in blue when it really needed to be A1... Fixed it now.
Here’s a quick breakdown on INDEX (shortened from Help) ...
Returns the value of an element in a table selected by the row and column number indexes.
INDEX(array,row_num,column_num)
Row_num selects the row in array from which to return a value. If row_num is omitted, column_num is required.
Column_num selects the column in array from which to return a value. If column_num is omitted, row_num is required.
=INDEX(A2: B3,2,1) returns the value at the intersection of the second row and first column in the range
=IF(COUNTA(A$1:A$1000)<ROWS(A$1:A1); ""; INDEX(A$1:A$1000;COUNTA(A1:A$1000)))
The formula was highlighting A1 in blue when it really needed to be A1... Fixed it now.
Here’s a quick breakdown on INDEX (shortened from Help) ...
Returns the value of an element in a table selected by the row and column number indexes.
INDEX(array,row_num,column_num)
Row_num selects the row in array from which to return a value. If row_num is omitted, column_num is required.
Column_num selects the column in array from which to return a value. If column_num is omitted, row_num is required.
=INDEX(A2: B3,2,1) returns the value at the intersection of the second row and first column in the range