Category Archives: UDFs

Working with array functions

Posted on 10/12/2014 by dougaj4

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

Posted on 08/12/2014 by dougaj4

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 , , , , | 10 Comments

Extracting numbers from text and regular expressions

Posted on 30/11/2014 by dougaj4

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 , , , , | 4 Comments

Range tips

Posted on 17/11/2014 by dougaj4

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

ExcelPython2, Alglib and Spline-Matrix Rel 2.03

Posted on 06/10/2014 by dougaj4

Following a comment here: ExcelPython2, Alglib and Spline-Matrix update I have updated the VBA and Python code, and added a missing Python module to the download zip file.  See the earlier post for details of installation and use, or download the revised files … Continue reading →

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