Excel Guides

How to Determine Sorting Criteria in Excel

When working with data in Microsoft Excel, it is often necessary to sort that data in order to better analyze it. For example, you may want to sort a list of employees by their last name, or a list of products by their price. Luckily, Excel makes it easy to sort data using a variety of criteria.

Sorting Data in Excel

In order to sort data in Excel, first select the cells that you want to sort. Then, click the Data tab on the ribbon and click the Sort button. This will open the Sort dialog box.

In the Sort dialog box, you will see a list of the columns in your data. For each column, you can specify a sorting criterion. To do this, click the drop-down arrow next to the column name and select the criterion that you want to use.

There are a few different options for sorting criteria. The most common are Ascending, which sorts the data from smallest to largest (or alphabetically from A to Z), and Descending, which sorts the data from largest to smallest (or alphabetically from Z to A).

You can also use more specific criteria, such as Number, Date, or Text. These options will sort your data according to those specific types of data. For example, if you have a column of dates, selecting the Date criterion will sort those dates chronologically.

(Note: The specific sorting criteria options will only be available if your data contains values of that type. For example, if all of the values in a column are numbers, then only the Number option will be available.)


>>> Sorting by Multiple Criteria


> To sort by multiple criteria:


1) In the Sort dialog box, select the first column that you want to sort by.
2) Click the drop-down arrow next to that column name and select the criterion that you want to use.
3) Click the Add Level button.
4) In the newly added level, select the second column that you want to sort by.
5) Click the drop-down arrow next to that column name and select the criterion that you want to use.
6) Repeat steps 3-5 for each additional column that you want to sort by.

7) When you have added all of the levels that you want, click OK.

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.