Oct 08 2019 12:57 AM
Oct 08 2019 01:20 AM
Please attach your sample file to illustrate your data layout and desired results.
Oct 08 2019 01:48 AM
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
Oct 08 2019 01:50 AM
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