Hello
I have the following formula.
=INDEX(FILTER($A$3:$O$63,ISNUMBER($M$3:$M$63)),SEQUENCE(ROWS($A$3:$O$63)),{2,3,13})
I would like to make it dynamic so I can drag across my various columns e.g.:
=INDEX(FILTER($A$3:$O$63,ISNUMBER($M$3:$M$63)),SEQUENCE(ROWS($A$3:$O$63)),{2,3,14})
=INDEX(FILTER($A$3:$O$63,ISNUMBER($M$3:$M$63)),SEQUENCE(ROWS($A$3:$O$63)),{2,3,15})
I thought about using INDIRECT(A1) but this does not seem to work. Where A1 = {2,3,13}
Any thoughts would be much appreciated - thanks
Bookmarks