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
