The spreadsheet presented in the last post on sorting also includes links to many other Numpy functions. The spreadsheet and associated Python file can be downloaded from:
The Numpy functions require xlwings and Numpy to be installed, which are included in the (free) Anaconda Python default installation.
All the Numpy functions in this spreadsheet return an array. The whole array may be displayed either by entering as an array function, or using xlwings dynamic array formulas. The spreadsheet also includes two VBA macros to display the entire array function (press Ctrl-Shift-S), or to re-size the display to the selected range (press Ctrl-Shift-R). The next post on this topic will give more details.
The Numpy functions included are shown in the screenshots below. See the Numpy Documentation for more details.:
xl_PolyFit fits a polynomial to scattered data
Maths functions operating on arrays:
Floating Point Functions: