# Excel Challenge 9

Claudia Buckley

#### Join the Excel conversation on Slack

Ask a question or join the conversation regarding Excel challenges on our Slack channel.

Start working on the Excel challenge with this data workbook

Ready to tackle this month’s Excel challenge?

The main task seems innocent enough - sorting data. But how much do you really know about sorting in Excel?

Here’s what to do:

• First, watch the challenge video and read the instructions below the video.
• Review the previously published video(s) and article(s) suggested.
• Put yourself to the test!

## The challenge

The school board has a list of all the schools in the district - from elementary to post-secondary, showing their city or town and population. They got an intern to put all this data together, but he sorted the dataset by the name of the school, which isn’t statistically useful to the Board.

What they really want is to sort schools alphabetically by town. Each town should have its schools displayed in the following order:

• Elementary > Middle > High > Community College > University.

Towns that have more than one of the same school type should list the one with the larger population first.

In the cells to the right of the data, we want to determine the occupancy percentage (population vs. capacity) of each type of school. Occupancy levels should be shown from lowest to highest, left to right.

Both tasks sound simple, but our intern is stumped. Doing them manually would be too time-consuming. There must be a simpler way! What is it?

Watch our Sorting and SUMIF videos for clues, then solve the challenge:

Start working on the Excel challenge with this data workbook

## The solution

We hope you'll enjoy taking part in this challenge!

Stay tuned to the GoSkills Excel Resource hub for more Excel challenges, and check out our range of expert-led Excel courses for all skill levels to further sharpen your skills.