#1
|
|||
|
|||
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 |
#2
|
||||
|
||||
Are the numbers random or sequential? What is the criteria for selection? Once selected, how should they be identified? Moved? Help us to help you with specific information. Crystal balls are not available any longer to help us.
|
#3
|
|||
|
|||
I'm really confused here! Do you want to select cell A169 and cells A1:A29, or what?
|
#4
|
|||
|
|||
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. |
#5
|
|||
|
|||
At start you declared you need to select 30 cells, now it is 140 cells!?
OK! Let's it be 140 (or less, as you can't select 140 cells with your conditions, when you are e.g. on row 10). Define a dynamic range (Main Menu>Formulas>Name Manager) e.g. dnRange140 as Code:
=OFFSET(YourSheetName!$A$1,MAX((ROW()-140)-1,0),,MAX(MIN((ROW()),140),1),1) Edit. When you activate any cell on this sheet, then open Name Manager from menu, activate this Named Range, and then click on Refers To field, the current range of it will be marked as active on your sheet - so you can see which cells are included at this moment. |
Tags |
select cells |
|
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 |