Forum Discussion
Name manager dynamic range
Hello,
I would like to setup a dynamic range selection using excel Name Manager.
I found this function that almost do the job. The issue i have is that i want to select several columns and not only one. Any idea?
Below the found that is working with on column / i did not find a way to select multiple columns:
=OFFSET($K$1,1,0,COUNTA($A:$A)-1,1)
With this formula used in name manager, I will dynamically sélect all content columns K based on data of column A
What to do to select dynamically K to O Columns dynamically?
Thank you
I would like to setup a dynamic range selection using excel Name Manager.
I found this function that almost do the job. The issue i have is that i want to select several columns and not only one. Any idea?
Below the found that is working with on column / i did not find a way to select multiple columns:
=OFFSET($K$1,1,0,COUNTA($A:$A)-1,1)
With this formula used in name manager, I will dynamically sélect all content columns K based on data of column A
What to do to select dynamically K to O Columns dynamically?
Thank you
3 Replies
Perhaps
=OFFSET($K$1,1,0,COUNTA($A:$A)-1,5)or
=INDEX($K$2:INDEX($O:$O,COUNTA($A:$A)),0,0)if select starting from second row
Finally, I found the solution:
=OFFSET(Sheet1!$D$1:$E$1;1;0;COUNTA(Sheet1!$A:$A)-1;2)
to select multiple column:
1. select column range (in Red)
2. change the last digit (in orange) = number column you want to select if 2 columns put 2, etc.
Tks
