Hi! I’d appreciate it if anyone here could teach me how to sort by date in Google Sheets. Thank you in advance!
Share
Sign Up to our social questions and Answers Engine to ask questions, answer people’s questions, and connect with other people.
Login to our social questions & Answers Engine to ask questions answer people’s questions & connect with other people.
Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
Please briefly explain why you feel this question should be reported.
Please briefly explain why you feel this answer should be reported.
Please briefly explain why you feel this user should be reported.
You can use the SORT function in Google Sheets. This function is best if you want other column(s) to follow the sorting.
Here’s how:
1. Select a new column to place your sorted data.
2. Click the first cell and enter the SORT formula, which is:
=SORT(range, sort_column, is_ascending)
range – The data to be sorted.
Example: =sort(A1:B13,1,true)
sort_column – The index of the column in range or a range outside of range containing the values by which to sort.
Example: =sort(A1:B13,1,true) – 1 means you’ll base the sorting on the 1st column on the range
A range specified as a sort_column must be a single column with the same number of rows as range.
is_ascending – TRUE or FALSE indicating whether to sort sort_column in ascending order. FALSE sorts in descending order.
Example: =sort(A1:B13,1,true) means to sort in ascending order.
Optional: SORT(range, sort_column, is_ascending, [sort_column2, is_ascending2, …]) – Additional columns and sort order flags beyond the first, in order of precedence.
(Definitions from Google Sheets)
Here’s what that would look like:
You can also use it for data other than dates like numbers or alphabet. I think it’s the basic sorting function.
Notes:
Make sure the cells you’ll put the sorted data are empty, or it’ll become an error.
The SORT function is an array formula, which means you can’t change nor delete any element of the array, or the sorting result will become an error. If you want to change said cells, you could convert these cells to values first and then make the changes.