If you are an accountant, a human resource manager, or your job involves inventory of goods, etc., then determining the order of values by date (ascending, descending) will Support us a lot in summarizing and setting group values, depending on your job requirements.
Yes, and in today's Excel lesson, I will share with you a little trick on filtering and sorting values by increasing, or descending by day - month - year on a spreadsheet using built-in filters. on Excel. Help you set up Excel spreadsheets more quickly and conveniently.
Read more:
#first. Sort data by increasing date
+ Step 1: First, open the Excel file you need to process.
+ Step 2: Here, you create a selection of date data on the spreadsheet by bôi đen vùng dữ liệu as shown below => and then open the tab Data up => and select:
- Sort A to Z (sorted in ascending order).
- Sort Z to A (sorted in descending order).
For example, here I will arrange in ascending order offline.
+ Step 3: Dialog box Sort Warning displayed, you click on Expand the selection => then press Sort to execute.
Results: The dates in the spreadsheet have been sorted in ascending order, from the oldest to the youngest.
#2. Sort data by descending dates
Similarly, to sort in descending order, you choose is Sort Z to A as shown below.
At the dialog box Sort Warning you ticked on Expand the selection => and click Sort.
Finally, we sorted the spreadsheet values by descending date.
# 3. Epilogue
Okay that's it, I have detailed instructions for you How to use the Sort filter How to sort Excel worksheet data in date format in ascending or descending order simply, and easily.
Here the tutorial article How to sort data by date in Excel, my would also like to pause. Hope this tip will be helpful to you.
Good luck.
CTV: Luong Trung - Blogchiasekienthuc.com
Note: Was this article helpful to you? Do not forget to rate the article, like and share it with your friends and relatives!
0 Comments