i-nth - The dangers of binning in Excel

19 December 2015

In Excel we can bin numbers. We can also bin letters. Rare but possible. However, be careful when binning a mix of letters and symbols! What could go wrong? A student who earns a B- could end up with an A- grade!

This happens because the TRUE option of the MATCH function doesn't work as you might expect.

Full article: The dangers of binning in Excel

Essential reading

Spreadsheet errors: What we know; what we think we can do

Research concludes unanimously that spreadsheet errors are both common and non-trivial. We must seek ways to reduce spreadsheet errors.

Latest articles

Spreadsheets as a source of analytical and accounting problems
Self-checks in spreadsheets: A survey of current practice
The development of a structured methodology for the construction and integrity control of spreadsheet models
Refactoring meets spreadsheet formulas
Simple spreadsheet test case application to test spreadsheet formula in end-user software engineering
Proper VBA error handling
VBA Like operator – using wildcards in conditional statements
Count cells with text and formula – Excel stats
VBA: The VBA array
Excel Tables
An innovative spreadsheet authoring environment

Consulting

We can help you make better spreadsheets:

Reviewing your spreadsheets for errors.
Advice about improving your spreadsheets.
Training in spreadsheet good practice.