I need to make a selection that starts in cell A169 and ends in cell A29. The matrix has 173 rows - it starts at A1 and ends at A173.
I tried =INDEX($A$1:$A$173, ROW(INDEX($A$1:$A$173, 169)):ROW(INDEX($A$1:$A$173, 29))) but it gave an error.