Imagine a weekly task of sending out a simple report. To do this you rely on data from someone else. When the layout of the data changes chaos reigns! What can we do? Continue reading
Data Disaster: non normalized data
Posts Tagged → Binning
Overlap of Binning and Rounding in Excel
Binning numbers and rounding numbers are two separate things in Microsoft Excel. However, there is one interesting binning twist that can be solved using a rounding function. Continue reading
Video 00174 Ranking Values into Tiers in Excel
Last year I started visiting some REDDIT Excel groups. A few weeks ago I saw an interesting Excel question and provided a simple two step solution. Continue reading
What is the easiest way to calculate grades in Excel?
Although the VLOOKUP versus INDEX/MATCH debate gets most of the attention there are MANY more topics to debate in Excel. When calculating student grades what method is best: NESTED IF or LOOKUP/BINNING TABLE? Continue reading
Video 00142 Horizontal list to Vertical list (layered transpose)
We don’t always find out how data got twisted into awkward forms. Our job is to fix it by normalizing, unwinding, transposing, etc. Once the data is in the correct format we can then get to the real job of extracting meaning from it. Continue reading
The Dangers of Binning in Excel
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! Continue reading
12 Different Binning Solutions & Ideas
What does binning numbers into groups have in common with TV? Well…probably nothing but I had fun combining these ideas while creating this Excel file. Continue reading