Category Archives: Computing – general

The answer to Life the Universe and Everything …

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 , , , , | Leave a comment

Installing Adobe Reader non-DC version.

The option to install a non-DC version of Adobe Reader used to be hidden away under a menu on the DC installation screen.  It seems that Adobe would really, really like you to use the DC version, because the other … Continue reading

Posted in Computing - general | Tagged , , | Leave a comment

Python Problems

I have recently returned to using Pyxll to link Excel to Python (of which more later), which required the installation of a 32 bit version of Python 3.7.  First trials after installation returned the message: “AttributeError: ‘module’ object has no … Continue reading

Posted in Computing - general, Link to Python, NumPy and SciPy | Tagged , , , | Leave a comment

New Links – 2018

Some new links to active Excel related blogs: David Hagar has been active in the Excel community for many years, and has published the Excel For You blog since 2013.  I was led to it by a recent post on a UDF … Continue reading

Posted in Computing - general, Excel | Tagged , , , , | Leave a comment

Office Insiders and Power Pivot

I recently discovered another benefit of the Office Insiders program through the ExcelUnplugged blog, which has a feature on the new linked data types in Excel.  More on those another day, but in addition to JavaScript UDFs, the added feature that I found to … Continue reading

Posted in Computing - general, Excel, Javascript | Tagged , , , | Leave a comment

The Countif bug (and how to avoid it)

The Countif function counts the number of cells in a range that match some criterion.  If we enter 1,2,3 in cells A1:A3 and enter =COUNTIF($A$1:$A$3,A1) somewhere else, it will return 1: But if we enter three text strings with 16 … Continue reading

Posted in Computing - general, Excel | Tagged , , , , , | Leave a comment

Excel Uservoice and Python for Excel

The Excel Uservoice site is a forum for users to post suggestions for improvements to Excel.  A suggestion to add native Python support to Excel, as a replacement to VBA, has had by far the most votes since the start, and … Continue reading

Posted in Computing - general, Excel, Link to Python, VBA | Tagged , , , , | 1 Comment