|
Formula containing a Spill Reference producing _xlfn_ANCHORARRAY()
A formula reference to a dynamic array can use the spill reference suffix #. For example =SUM($B$3#) will SUM the entire dynamic array that starts in $B$3. Spill references get converted to _xlfn_ANCHORARRAY(Reference) in previous versions and will result in #Name when calculated.
CheckDA will flag such formulas as type {#}
|
