Forum Discussion
Using Scan function with Oddly shaped arrays
I have two arrays of different shares. One array is a set of values. The other is a set of growth rates. The challenge is to apply the scan function to get the an array of values that are increased...
PeterBartholomew1amazing response. Here is a dumb question. Why does this not work:
In a way it does work! It returns an array of 5 functions, any one of which will generate some 0s if executed. Picking one out
INDEX(triangle,5,1)()will return the 5th row for example.
What you cannot do is evaluate the array of functions directly
= triangle()
because TYPE(triangle) = 64 (array)
whereas
= TYPE(INDEX(triangle,5,1)) = 128 (function / rich data type)and can be evaluated