You are here Function return Dynamic array Calculating in array and returns it to spreadsheet with BS_FillArray

Calculating in array and returns it to spreadsheet with BS_FillArray

The simplest way is to perform the calculation in the array and return this array to the Excel spreadsheet with function BS_FILLARRAY of the Add-in A-Tools.
 
=BS_FILLARRAY(array, ["Options"])
 
Example:
1. Return array from function INDEX()
=bs_FillArray(INDEX(E5:N14,,P4)))
2. Append multiple array and return it to spreadsheet
=bs_FillArray(BS_ARRAY2D(A1:D10, A14: D20, D1:G20))
 
3. Append multiple array and return it to spreadsheet, set option INSERT in formula
=bs_FillArray(BS_ARRAY2D(A1:D10, A14: D20, D1:G20), "INSERT=YES")
 
3. Append multiple array and return it to spreadsheet, set option INSERT, create NAME in formula
=bs_FillArray(BS_ARRAY2D(A1:D10, A14: D20, D1:G20), "INSERT=YES; NAME=MixData")
 
Video Help 1

Video Help 2

Video Help 3