Forum Discussion
Solved
Getting the above value of the currently processed array (result array during formula execution)
Hi, I know how to get a value from an above cell of a cell with a formula being executed but I am struggling to do the same with an array. You can simply refer to the above cell and then let the dra...
You comment on StackOverflow " I only get "From Table/Range" . But this one works with dynamic arrays as well. At least you may try if Power Query in attached file works in your environment.
aaboodi If you can't connect to the DA, why not create a named range called "myRange", for instance, referring to B3# and connect to that named range in PQ and use the Fill Down there?
