Tag Archives: UDF

Using LinEst() on data with gaps

Posted on 14/05/2011 by dougaj4

A comment on Using LINEST for non-linear curve fitting asked if it was possible to use the function on data with gaps.  There are several options: Copy and sort the data to remove the gaps. Use the chart trendline function Use … Continue reading →

Posted in Arrays, Excel, UDFs, VBA | Tagged , , , , | 40 Comments

Using Array Formulas

Posted on 10/05/2011 by dougaj4

Many of my User Defined Functions (UDFs) return an array of values, that requires a special procedure to make all the values visible. I have usually given a brief description of the procedure with the UDF, but for convenience for … Continue reading →

Posted in Arrays, Excel, UDFs | Tagged , , | 20 Comments

Beware of the mod

Posted on 22/04/2011 by dougaj4

Playing with a simple VBA user defined function (UDF), inspired by a thread at Daily Dose of Excel, I was finding it was mysteriously giving the wrong answer. The task was to find the angle between the hands of an … Continue reading →

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

Calling Add-in functions from VBA

Posted on 16/04/2011 by dougaj4

When an Excel add-in is active any User Defined Functions (UDFs) in the add-in are available to any other open worksheet.  It might be expected that the same would apply to VBA routines defined in other files, but if you … Continue reading →

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

Tanh-Sinh Quadrature V2.0

Posted on 04/04/2011 by dougaj4

I recently received an update of the Tanh-Sinh Quadrature spreadsheet from Graeme Dennes, which can be downloaded from:  Tanh-Sinh Quadrature (including, as usual, full open source code). – Link fixed 5th April 2011 Here is Graeme’s description of the updates: The … Continue reading →

Posted in Excel, Maths, Newton, Numerical integration, UDFs, VBA | Tagged , , , , | 2 Comments