Author Archives: dougaj4

Lambda and VBA

Posted on February 28, 2021 by dougaj4

The new Excel Lambda function (see here for more details and links) is currently only available to those signed up to the Beta Preview version of Excel 365, but is has been favourably reviewed by almost all of those who … Continue reading →

Posted in Computing - general, Excel, UDFs, VBA | Tagged , , , , | Leave a comment

Eval and Let examples

Posted on February 21, 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 , , , , , | 8 Comments

Ebony Buckle, New Scientist, and the 52 Hz Whale

Posted on February 19, 2021 by dougaj4

We last heard from Ebony Buckle here nearly 8 years ago, but I noticed her name in an article on the back page of last week’s New Scientist, which noted that her latest work was inspired by the World’s loneliest … Continue reading →

Posted in Bach, Newton | Tagged , , , , | Leave a comment

Two New Functions; Let and Lambda

Posted on February 14, 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 , , , , | 2 Comments

Python callable arguments from Excel

Posted on January 29, 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 , , , , , , , | Leave a comment