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 ...
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