i-nth logo
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