Category Archives: Computing – general

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

Running exe files from Excel

Following on from the previous post (running a compiled Fortran finite element analysis program from Excel), this post looks at the details of calling any command line routine from Excel, through VBA.  The important points that need to be addressed are: Writing … Continue reading

Posted in Computing - general, Excel, Finite Element Analysis, Fortran, Geotechnical Engineering, Newton, VBA | Tagged , , , , , , , | 2 Comments