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

# 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