DigDB      Excel Add-ins      Add-in Tools for Excel Elites
Who else wants to do a 10-hour Excel analysis in 15 minutes? (more ...)

Features | Testimonial | Download free 15-day trial | Purchase | FAQ | Contact

Sort table by more than three levels in Excel

Multi-level sorting is often needed. In the table below, suppose we want to rank the 'Tester's. We want to first sort by 'Average Score' descending, then if there is a tie, sort by 'Count of Tests' descending, then if there is a tie, sort by 'Best Score' descending, then in case of a tie, sort by 'Worse Score' descending. That is a complete sorting which requires four levels of sorting, each taking place within the result of last sorting.
    Excel sorting - multiple levels

Multi-level sorting is limited in Excel. Excel's default sorting allows a max of 3 levels. DigDB breaks this limit and allows you to sort by as many levels as you need.

  1. Click a single cell in your table area. Invoke 'DigDB->Sort->CrossTab to List...'. The table area will be automatically selected.

    Excel sorting - multiple levels
    Practice file - sort-many-levels-demo.xls (16k)

  2. Set the sorting criteria and order

    Excel sorting - multiple levels

    Select which columns to sort by.

    Excel sorting - multiple levels

    Use 'Then by' button to add more columns to sort by

    Excel sorting - multiple levels

  3. Click 'OK' to start sorting. Result is:

    Excel sorting - multiple levels

Note that at each level, you can set the sorting options to Ascending or Descending, Case sensitive or Ignore case. In addition, you can also choose special sorting options for each column, for example, sort by text length, text value, font style, weekday name, month name.
    Excel sorting - multiple levels

Need more?


Features | Testimonial | Download | Purchase | FAQ | Contact

Copyright © 1999-2007 All rights reserved

DigDB      Excel Add-ins      Add-in Tools for Excel Elites
Who else wants to do a 10-hour Excel analysis in 15 minutes?

Related keywords: Advanced excel tips, excel questions tools, Excel reporting applications, Excel add-ins add-in, Excel shareware, Excel plugin plug-ins plugins, Excel tricks question, Excel utility utilities, Excel add-on add-ons, Excel tip tips, Power excel technique, Excel manipluation, Excel guru, Excel trick, Excel toolkit, Excel app power user

Microsoft Office Marketplace logo
Microsoft and the Office logo are trademarks or registered trademarks of
Microsoft Corporation in the United States and/or other countries.