Category Archives: Computing – general

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

Excel Uservoice and Python for Excel

Posted on 18/12/2017 by dougaj4

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

Posted on 27/05/2017 by dougaj4

Edit 3rd Jan 2026: This download is not currently available. 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 … Continue reading →

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