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”.