Skip to main content
me selecting custom sort in microsoft excel

Excel : how to sort tabel on custom criterea [custom sort]

This will allow us to sort multiple collums of data. If we use the normal sorting function we will mix our data.
In this example we use a list of the largest companies in the world by revenue.

Step 1: Select the tabel you want to sort

Step 2: Select “Sort & filter” in the top right of your screen. Then select “Custom Sort…”.

step 3: Now in the dialog box select by wich value you want to sort the table. In this example I want to find out which company has grown the most.

step 4: Then we can choose to sort “largest to smallest” or “smallest to largest”.

 

 

 

 

 

Leave a Reply

%d bloggers like this: