Name manager dynamic range

[Anthony44]

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

[#2]

@Anthony44 

Please attach your sample file to illustrate your data layout and desired results.

[#3]

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

[#4]

@Anthony44 

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