Data clean-up techniques in Excel: Classifying values

This article requires that you know Data clean-up techniques in Excel: Transforming Data with Formulas

Sometimes it may be necessary that you will classify the values into a group. For example, if you have a file that lists ages of people, you might want to classify them into groups such as 17 or younger, 18–24, 25–34, and so on.

Download sample file to work with classifying values in Excel

You can do this classification using a Look Up table. The following image shows ages in column A under “Age” header, and classifications of ages under “Classification” header in column B. Column B uses the look-up table in D5: E12. The formula in cell B5 is =VLOOKUP(A5,$D$5:$E$12,2)

In this example, we have used absolute cell reference with a $ sign before cell references. Then copy the formula for the cells below. You will get your result like the following image.

Classifying values in Excel

Using a look-up table to classify ages into age ranges.

Read More…

Exporting Data in Excel

Data clean-up techniques in Excel: Matching text in a list

Data clean-up techniques in Excel: Extracting a filename from a URL

Hello! Welcome to my Excel blog! It took me some time to be a fan of Excel. But now I am a die-hard fan of MS Excel. I learn new ways of doing things with Excel and share here. Not only how to guide on Excel, but you will get also topics on Finance, Statistics, Data Analysis, and BI. Stay tuned!

We will be happy to hear your thoughts

      Leave a reply