From the course: Excel 2016 for the Mac: Managing and Analyzing Data

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Sort based on data order in custom lists

Sort based on data order in custom lists - Microsoft Excel for Mac Tutorial

From the course: Excel 2016 for the Mac: Managing and Analyzing Data

Start my 1-month free trial

Sort based on data order in custom lists

“

- [Instructor] In this worksheet called CustomLists in our chapter one file, let's imagine that we might want to sort this list based on status in column F. There are four kinds of status: full time, half time, contract, and hourly. If we click in column F in any cell, not clicking the column letter, but any cell within column F, we can quickly rearrange this data by going to the data tab and clicking AZ. And Excel does its job. The contract people come first. Alphabetically that precedes the next status that we see in the list, full time, and then much much later in the list here, the biggest cluster by far is for full time people, after full time then we see in the list half time. And then finally hourly. Now you could easily imagine someone wanting to say well let's put the full time people first. They run the company, they in a certain sense are more important than the others. So why can't we get the full time people first? Could we do a ZA sort? Well we could try that, and what…

Contents