Author Archives: dougaj4

Regular Expressions in Excel

Posted on 25/05/2024 by dougaj4

I recently discovered that Microsoft are working on Excel functions to work with Regular Expressions. A beta version is currently available to those on the “insider” program, but this functionality has long been available through VBA, and can also be … Continue reading →

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

Pale Blue Dot

Posted on 24/05/2024 by dougaj4

34 years ago Carl Sagan presented an image of the Earth taken from outer space, known as the pale blue dot. An event very different from a 13 year old boy singing a song he had written himself, but the … Continue reading →

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

Rory Phillips – The Truth

Posted on 13/05/2024 by dougaj4

“‘The Truth’ is a passionate call to action on climate change from 13 year old Rory Phillips. “I wanted to say something with this song. The lyrics are subtle, not in your face; but the message is clear. We need … Continue reading →

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

Creating sequential lists in Excel

Posted on 08/05/2024 by dougaj4

I recently discovered that Excel has a new SEQUENCE function that will return a sequence of increasing numbers in a column, row, or 2D range. Use of the new function is shown in the screenshot below, with some old and … Continue reading →

Posted in Excel, Link to Python, PyXLL, UDFs | Tagged , , , , | Leave a comment

Let, Lambda, and py_Eval

Posted on 21/04/2024 by dougaj4

I have covered the new Excel Let and Lambda functions before at: Two New Functions; Let and Lambda Eval and Let examples Lambda and VBA The Lambda function is now available to all Microsoft 365 subscribers, so I have now looked at … Continue reading →

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