Join Dennis Taylor for an in-depth discussion in this video Multiple-key sorting, part of Managing and Analyzing Data in Excel (Office 365/Excel 2019).
but in multiple columns. by grouping primarily by department. And within that and maybe in some of the larger departments we might want them to be in order too Anytime your about to sort on multiple levels or maybe if you only use sorting occasionally I strongly recommend using the larger Sort button and oddly enough it has two different names On the home tab in the ribbon menu system you will see the larger button And here's the dialog box that pops up. I'll close this. Where we find our other data management tools. In the first panel here under Sort By we can add the other names right now if we wish or go to the right and consider other choices we might want. Nearly always for most people if we're talking about a text field Within each department we want these to be in order by their status. That too, text field A to Z. Let's add another level. every time we've got a group of people same status same department Employee name. Now we can do four, five, six One other thing to check here before sorting always make sure that Excel has either figured out or hasn't If this were unchecked here and we didn't pay any attention and sorted the data Excel nearly always gets this right so usually you don't worry about it too much. So we're going to click Okay and this list will be in order. Department status, years, employee name. these people here Now highlighting those differently we'll see So one by one you quickly pick up on the idea The other reason for using that button not necessarily on cell values but also by cell color font color or icon. If you only use sorting occasionally within a list.
- Prepping data for analysis
- Multiple-key sorting
- Sorting based on custom lists
- Creating single- and multi-level subtotals
- Using text, numeric, and date filters
- Filtering tables using slicers
- Using the Advanced Filter
- Eliminating duplicate data
- Using SUMIF and related functions for quick data analysis