Category Archives: Computing – general

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

Working with milliseconds in Excel

A recent post at Eng-Tips looked for a solution to problems with working with times in Excel, when time differences are required to the nearest millisecond. The problem is that although times may be entered as a time/date value, and formatted … Continue reading

Posted in Computing - general, Excel, UDFs, VBA | Tagged , , , , , , | 1 Comment

Indexing pdf content, again

I discovered today that my latest computer (with 64 bit Windows 10) had not been indexing the content of pdf files, which makes doing a search on local file content pretty much a waste of time.  Checking the file search settings … Continue reading

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