Category Archives: Excel

Goal Seek Macro for Multiple Sheets

Posted on 30/01/2013 by dougaj4

Following a comment on the Using Goal Seek on Multiple Cells post, I have modified the macro so that the goal-seek ranges can be on a different sheet to the named input ranges.  The new file can be downloaded from: GSeek.zip. … Continue reading →

Posted in Excel, VBA | Tagged , , , | 4 Comments

Precise Angles and XNumbers

Posted on 28/01/2013 by dougaj4

Further to comments by Georg under: The angle between two vectors, in 2D or 3D I have added four alternative ways of calculating the angle between two 3D vectors to the VectorFunc spreadsheet.  The new version can be downloaded from: http://interactiveds.com.au/software/VectorFunc.xlsb. … Continue reading →

Posted in Coordinate Geometry, Excel, Maths, Newton, UDFs, VBA | Tagged , , , , , | Leave a comment

Charts and Charting

Posted on 27/01/2013 by dougaj4

I don’t do a lot on Excel charts because there are already a number of excellent blogs and sites that specialise in that area; notably: Peltier Tech Blog but after compiling my “Downloads by Category” page I found that I … Continue reading →

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

New Page

Posted on 26/01/2013 by dougaj4

In an effort to make the information on this site easier to access I have collected all the “Daily Download” posts from last year onto a new page, listing each of the download posts by category. It’s called “Download by … Continue reading →

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

Counting unique values from a range or array

Posted on 26/01/2013 by dougaj4

About this time last year, I posted a User Defined Function (UDF) that would return a list of unique items from a list: https://newtonexcelbach.wordpress.com/2012/01/31/retrieving-unique-values-from-a-range-or-array/ That post has recently received a few comments, and coincidentally Colin Legg at RAD Excel has … Continue reading →

Posted in Excel | Tagged , , , , | Leave a comment