Recent Comments
Brad Clarke on Section properties for groups… 
dougaj4 on Section properties for groups… Brad Clarke on Section properties for groups… Brad Clarke on Section properties for groups… dougaj4 on Dots and Crosses 
Stephen Cooke on Dots and Crosses dougaj4 on Two songs = 2/3 Wikipedia 
Tom Barsh on Two songs = 2/3 Wikipedia 
Jon Peltier on Two songs = 2/3 Wikipedia Returning Arrays Fro… on More Numpy with Excel and… More Numpy with Exce… on Using Array Functions and… More Numpy with Exce… on Sorting with Python and N… Office Insiders and… on JavaScript UDFs in Excel Sorting with Python… on Sorting with VBA and Pyth… Sorting with VBA and… on Dynamic sorting with Excel, VB…
Tag Archives: bug
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
A very un-useful “feature”
A recent post in the Engineering Spreadsheets forum at Eng-Tips draws attention to a potentially dangerous Excel “feature”. The feature is called “Extend data range formats and formulas” and can be found under Options-Advanced (click on the multi-coloured button in the … Continue reading
