Category Archives: Excel

Running VBA routines from a new workbook

Posted on 21/08/2013 by dougaj4

I have had a couple of queries recently which seem to be resulting from trying to run User Defined Functions (UDFs) from a new workbook, so this post will look at the options for using the VBA routines provided here (or … Continue reading →

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

Chain mail …

Posted on 11/08/2013 by dougaj4

… or a collection of inter-connected links (all e-mailed by Alfred Vachris, and all worth a look): 3D scatter plot for MS Excel – free spreadsheet with proper 3D scatter plot function. Excel Liberation This is not another Excel tips … Continue reading →

Posted in Excel | Leave a comment

Select and sum data using the scripting dictionary

Posted on 10/08/2013 by dougaj4

Another User Defined Function (UDF) prompted by a query at Eng-Tips. The question concerned a set of data consisting of 13 columns, which was to be divided into two sets, based on the contents of Column 4, then the contents … Continue reading →

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

EvalA update and examples

Posted on 06/08/2013 by dougaj4

The EvalA User Defined Function (UDF) has been included in the Eval2 and Eval-Integration spreadsheets for some time, but was not documented.  That has now been fixed, and both spreadsheets can be downloaded from Eval2.Zip (including full open-source code). The … Continue reading →

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

SelectAv Function

Posted on 30/07/2013 by dougaj4

Suppose you have a spreadsheet range containing numerical data, and would like to find the average for a number of the most recent values, ignoring the highest (and/or lowest) values from the selected set. If you like using long array … Continue reading →

Posted in Excel, Maths, UDFs, VBA | Tagged , , , | 3 Comments