Slider

How to Sort Data in Excel by Multiple Conditions

Date:2019-7-9 Author:Cordelia

In my previous post I’ve introduced the method of sorting data in Excel by single condition. But in actual operation we usually need to sort the data according to more than one conditions. How can we do that?

For example, there are some students with the same score in the grade table such as Ray and Zoe. So I want to sort these data mainly by the value of grade but also take the first letter of name into consideration.

How to Sort Data in Excel by Multiple Conditions

Put the cursor in any cell of the table, click DataSort.

How to Sort Data in Excel by Multiple Conditions

Set the specific condition in Sort window. In my case the first level is Grade, from Largest to Smallest. Then click Add Level, set Name as the second level and the Order is from A to Z.

How to Sort Data in Excel by Multiple Conditions

Hit OK, then the data will be sorted by the order you customized. You can see that when the grades are the same, the data will be sorted by students’ name.

How to Sort Data in Excel by Multiple Conditions

Copyright Statement: Regarding all of the posts by this website, any copy or use shall get the written permission or authorization from Myofficetricks.

Leave a Reply

Your email address will not be published. Required fields are marked *