Recent Comments
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 CLSIDToPackageMap, installation, Python, py_gen
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 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
