Google Sheets Sort Function | Sort Data in Ascending or Descending Way | Sort Data Manually
Use the Google Sheets SORT function to sort the data in a range. The three mandatory attributes or inputs you should provide to the Google Sheets SORT function are the range, number of the column having the data to be sorted, and the sort order, that is ascending or descending.
--------------------------------------------------------------
The FILTER function filters data based on one or more conditions. Here's the link to the video tutorial on FILTER:
• Google Sheets Filter Function | Extra...
--------------------------------------------------------------
The SORT function optional attribute is the second sort column number and sort order, third sort column number and sort order, and so on.
If the data in the source range changes, the sorted data gets updated automatically.
Here is the format of the Google Sheets SORT function:
=SORT(range, sort_column, is_ascending, [sort_column2, is_ascending2,
...])
Start the formula with the equal-to symbol.
SORT is the name of the function.
range is the area of the spreadsheet with the data to be sorted.
sort_column is the number of the column with the data to be sorted.
is_ascending has a value of TRUE or FALSE. If TRUE data will be sorted in ascending order. If FALSE data will be sorted in descending order.
sort_column2 is the additional column to be sorted.
is_ascending2 is the sort order for sort_column2.
Let's look at an example of SORT:
=SORT(A76:D85,2,TRUE)
Range is cells A76 to D85.
sort_column is 2. That is, the data in column 2 will be sorted.
is_ascending is TRUE. The data will be sorted in the ascending order.
For is_ascending, the value can be TRUE or 1, or FALSE or 0.
You can also sort data in Google Sheets without using the formula. Here are the steps:
Select the range you want to sort, click Data, click Sort range, select the column to sort by or accept default, and specify the sort order.
Take a look at this video tutorial, which has two parts. The first part gives the steps to sort data using the Google Sheets SORT function. The second part gives the steps to sort data without using SORT. Both the parts have an example.