Tag Archives: Excel

The answer to Life the Universe and Everything …

Posted on 19/09/2019 by dougaj4

is 42, as is well-known: The actual question, to which the answer is 42, is not known, but a lesser known long standing question involving this number has recently been solved: The original problem, set in 1954 at the University … Continue reading →

Posted in Computing - general, Excel, Maths, Newton, PyXLL | Tagged , , , , | 5 Comments

Plotting Mandelbrot

Posted on 15/09/2019 by dougaj4

There are many sites discussing the Mandelbrot Set, but not many examples using VBA to plot the set in Excel, so here is my effort: The spreadsheet (including open source VBA code) may be downloaded from: Mandelbrot chart.zip Note that … Continue reading →

Posted in Charts, Charts, Coordinate Geometry, Drawing, Excel, Maths, Newton, VBA | Tagged , , , | 3 Comments

Using conditional formatting with array formulas

Posted on 17/08/2019 by dougaj4

A recent Quora question asked “How do I highlight the number closest to an initial number in a row in Excel?“.  The answer by Bill Jelen provides a good example of using conditional formatting with an array formula: In my … Continue reading →

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

64 bit Excel and PtrSafe

Posted on 31/07/2019 by dougaj4

Installing my Office 365 subscription on a new computer I discovered it had decided (without asking) to upgrade itself to the 64 bit version, which resulted in some of my spreadsheets not working on the new system.  The main problem … Continue reading →

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

Solving the Lagrangian Point equation for the Moon

Posted on 23/06/2019 by dougaj4

This post was prompted by a recent question at Fitting high order polynomials, asking for Excel methods to solve the equations for the radius of the Moon’s Lagrangian Point 1. All the methods described in this post have been added to … Continue reading →

Posted in Excel, Maths, Newton, UDFs, VBA | Tagged , , , , , , | 4 Comments