Category Archives: UDFs

Numpy and Scipy for Excel

The Python Numpy and Scipy libraries contain a huge number of maths and science related functions.  Most of these are not directly available from Excel, but using the free ExcelPython package it is fairly easy to make the link, vastly increasing … Continue reading

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

Working with array functions

Regular visitors will know that I make frequent use of User Defined Functions that return an array of data, and need to be entered as an array function. This has the advantages that the functions are very flexible in the … Continue reading

Posted in Arrays, Excel, UDFs, VBA | Tagged , , , , | Leave a comment

More on Regular Expressions

The previous post presented a User Defined Function (UDF) using regular expressions to extract all numbers, or a selected number, from any string (or a list of strings).  In this post I will look more closely at the code used to achieve … Continue reading

Posted in Excel, UDFs, VBA | Tagged , , , , | 2 Comments

Extracting numbers from text and regular expressions

Daily Dose of Excel recently had a post on extracting a number from a specified position in a text string, using mega-in-sheet-formulas like: This reminded me of a post from earlier this year, which provided a User Defined Function (UDF) … Continue reading

Posted in Arrays, Excel, UDFs, VBA | Tagged , , , , | 1 Comment

Range tips

A couple of tips on Excel ranges, coming from questions on the Eng-Tips Forum: 1. How to rotate a range: The Transpose function (or option in the Paste-Special dialog box) will swap the rows and columns of a range, but … Continue reading

Posted in Excel, UDFs, VBA | Tagged , , , , | 6 Comments