Sorting is putting up a number of things in a particular fashion as per the selected criteria. Sorting in GOOGLE SHEETS is one of the very basic and frequently used operation.
SORTING IN GOOGLE SHEETS IS THE PROCESS OF ARRANGING THE TEXT OR VALUES SYSTEMATICALLY AS PER THE SELECTED CRITERIA.
For example, suppose there are five kids of different ages and different heights. Now, if we ask them to line up according to their ages, the youngest will be at the first place and the oldest at the last. (If its increasing order and opposite if its decreasing order). But if we want them to be according to height, the order maybe different from the previous case.
Sorting is such a frequent operation that you ‘d hardly create any report without having a single sort.
Sorting is needs to be done for the names, cities, values etc.
Sorting in GOOGLE SHEETS is one of the most important and frequently used function. We may need to sort the report as per requirement to search the particular data or see the trend. So lets start with simple sorting.
The picture below shows the button location for DATA SORTING in GOOGLE SHEETS
SORTING OPTION is found under the MENU DATA.
Data Sample: We have a range of different digits put in a line. Target is to put all the numerals in increasing order.
Google Sheets doesn’t use the word VALUES and TEXT separately. It’ll use the word RANGE and SHEET. The SHEET option performs the action on complete column TOP TO BOTTOM whereas RANGE OPTION will operate upon the selected range.
The above example is for a very simple case. In practical world, we’ll always have many columns on which we’ll be needing to be sorted. GOOGLE SHEETS gives us the option of giving many sorting operation simultaneously.
MULTILEVEL SORTING MEANS TO SORT THROUGH MULTIPLE COLUMNS.
Lets try with an example.
DATA consists of different students of different class and marks are shown.
The dialog box [ as shown in the picture above ] contains a few options.
DATA HAS HEADER ROW:
If our table has a header row which we have selected, check this option to remove the HEADER FROM BEING SORTED as we want the headings to be at the top only.
SORT BY: Choose the column on the basis of which we want to sort the data.
A —->Z : Increasing Order
Z —->A : Decreasing Order
STEPS: CONTINUED [CHECK OUT THE PICTURE BELOW]
Now, we need to add the levels.
After clicking the SORT BUTTON, the GOOGLE SHEETS will act on the data and give us the result.
Check the picture below for the result.
The Names are sorted first in alphabetical order, followed by the Age in increasing order followed by the Height in the decreasing order.
In this article we tried to learn about HOW TO SORT DATA IN GOOGLE SHEETS, HOW TO SORT DATA IN MULTIPLE LEVEL OR MULTI COLUMN. I hope you like the article.
Feel free to ask any query in comments.
OTHER WAYS TO REACH THIS ARTICLE
YOU MAY LIKE