16 December 2019

Perform Multi-Level Sorting in Excel

Perform Multi-Level Sorting

With Multi-Level Sorting, you can sort one column and then the second one is such a way that the first one is still sorted. the pic below might make it more clear:

Marks List before sort
After Sorting
How to :
1. Select the entire data set. 
2. Go to Data click on Soft and Filter then Sort as above pic
3. In the Sort dialogue box, select column sort by, Sort on and order values from drop down [for the subject column, i.e., the first level sorting ]
4. now click on the add level option at the top. This will add another sorting level 
5. Again select the sort criteria [for the marks column, i.e., the second level sorting]





















No comments: