Inside Microsoft Office

Assign categories to your numeric ranges automatically

Inside Microsoft Office

by Kara Hiltz

There are often easy-to-understand categories associated with numeric values, but it can be a hassle to assign these categories manually. And what if the numeric value changes? You’d need to remember to update the category too. For example, schools often assign grades to numeric ranges – such as a C for scores that fall between 70 and 79. Using our technique, the category updates depending on where the data falls within the[…]


Subscribe to Inside Microsoft Office

(get full access to archives and more)