Query, Share and Manage Excel workbooks on LAN, Internet

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))