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