Category Archives: Computing – general

Installing Adobe Reader non-DC version.

Posted on 26/06/2019 by dougaj4

Edit 3rd Jan 2026:  As noted in the comments, as far as I know, the old versions of Adobe Reader are no longer available from Adobe, and the links given in this post no longer work. The option to install a … Continue reading →

Posted in Computing - general | Tagged , , | 4 Comments

Python Problems

Posted on 29/11/2018 by dougaj4

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

Posted on 03/06/2018 by dougaj4

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

Posted on 20/05/2018 by dougaj4

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)

Posted on 22/12/2017 by dougaj4

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 , , , , , | 2 Comments