|
|
#4
02-05-2024, 10:25 AM
|
|||
|
|||
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. Last edited by xexeu; 02-05-2024 at 12:54 PM. 
|
| Tags |
| select cells |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Select a range of cells to cpy based on a text searh | oscarlimerick | Excel | 2 | 07-18-2023 01:27 PM |
 Select all cells in a column , even when blank...
|
Chayes | Excel Programming | 4 | 05-30-2018 10:35 AM |
| Conditional formating all cells in an array based on adjacent cells | deejay | Excel | 6 | 12-20-2016 12:00 PM |
|
Help with Index Function to Select Range of Cells
|
bretyuin | Excel | 1 | 02-24-2016 05:11 AM |
|
Convert String Array to Integer Array from a User Input?
|
tinfanide | Excel Programming | 4 | 12-26-2012 08:56 PM |
Windows 10 
Office 2016
Threaded Mode