Tag Archives: Excel

Eval and Let examples

Posted on 21/02/2021 by dougaj4

Final example updated 28th Feb 2021, following comment from Craig: There are many examples of the use of the new Let function on the web (see my previous post on this topic for links). This post compares use of Let … Continue reading →

Posted in Excel, Maths, UDFs, VBA | Tagged , , , , , | 9 Comments

Two New Functions; Let and Lambda

Posted on 14/02/2021 by dougaj4

Two new Excel functions have recently attracted a lot of attention; these are: LET (now available to Office 365 subscribers and LAMBDA (currently available to Office Insiders program only) Microsoft documentation can be found at: Announcing LET Have you ever … Continue reading →

Posted in Excel, UDFs | Tagged , , , , | 3 Comments

Python callable arguments from Excel

Posted on 29/01/2021 by dougaj4

Many Scipy functions have “callable” arguments, i.e. functions that can be called, with the returned data used as input by the calling function. Types of callable arguments include: Functions in the active Python module Functions in any active loaded library … Continue reading →

Posted in Excel, Link to Python, NumPy and SciPy, PyXLL, UDFs | Tagged , , , , , , , | 1 Comment

Python optional arguments from Excel – Part 2

Posted on 19/01/2021 by dougaj4

The previous post provided a method for using pyxll to pass optional arguments from Excel to Python whilst preserving the default values of any called Python function for arguments that were omitted in the Excel function. One condition where this … Continue reading →

Posted in Excel, Link to Python, NumPy and SciPy, PyXLL, UDFs, VBA | Tagged , , , , , | Leave a comment

Using Python optional arguments from Excel with pyxll

Posted on 14/01/2021 by dougaj4

Python functions allow optional arguments to be specified by allocating a default value to each optional argument. The pyxll add-in allows Python functions called from Excel to work in the same way, so any argument with a default value may … Continue reading →

Posted in Excel, Link to Python, PyXLL, UDFs | Tagged , , , , , , | 1 Comment