|
|
#1
02-03-2024, 06:56 AM
|
|||
|
|||
Select cells in an array
In column A I have numbers that are arranged in ascending order, in a range that goes from A! up to A174. If I have to select a certain number of cells, for example, 30 cells, and my initial cell is in line A169, I have to do it manually, starting with cell A169 and continuing the selection from cell A1 until completing the 30 cells.
Is there a way to do this operation using formulas? Thanks in advance 
|
| 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