Recent Comments
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 Excel, Excel for You, Excel Matters, links, My Spreadsheet Lab
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 Excel, Linked Data Types, Office Insiders, Power Pivot
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 bug, CHAR(173), COUNTIF, Excel, Sum, Sumproduct
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 Excel, Python, survey, uservoice, VBA
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 Excel, milliseconds, msTime function, time format, time rounding, UDF, VBA
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 64 bit ifilter, download Reader 11, fix pdf content indexing, index search, pdf
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
