Date Sort Column Rows
Date Sort Column Rows
if I have 7000 column rows how can I sort them by date? I have a vertical column row "J" that provides the date for each column row. How can i sort all 7000 column rows by the dates provided in vertical column "J"
- Attachments
-
- I have attach a picture with a description
OpenOffice 3.1 on Windows 10
Re: Date Sort Column Rows
Welcome!
(But: Why do you post an image instead of attaching the file (or a reduced representant)?)
The "dates" in column J you want to sort by are supposedly no dates at all in the way spreadsheets treat dates. They seem to be text.
(These texts are giving the dates in a different format than used in column I, the worst format now available in the world.)
If so: You have to convert the dates into numeric representation first. You can achieve this using the tool 'Data' > 'Text to Columns...' with 'Standard' and 'Column type' Date (DMY).
Dates given as text can only be sorted lexicographically in correct order if strictly observing the identical format on YYYY-MM-DD basis (ISO 8601).
(There are additional ways. Everyone is descibed in many older threads in this forum.)
(But: Why do you post an image instead of attaching the file (or a reduced representant)?)
The "dates" in column J you want to sort by are supposedly no dates at all in the way spreadsheets treat dates. They seem to be text.
(These texts are giving the dates in a different format than used in column I, the worst format now available in the world.)
If so: You have to convert the dates into numeric representation first. You can achieve this using the tool 'Data' > 'Text to Columns...' with 'Standard' and 'Column type' Date (DMY).
Dates given as text can only be sorted lexicographically in correct order if strictly observing the identical format on YYYY-MM-DD basis (ISO 8601).
(There are additional ways. Everyone is descibed in many older threads in this forum.)
On Windows 10: LibreOffice 25.8.4 and older versions, PortableOpenOffice 4.1.7 and older, StarOffice 5.2
---
Lupp from München
---
Lupp from München
Re: Date Sort Column Rows
Also, can I attach a file that is over 128KB? The file I am using is currently over 2MB.s? I went to DATA> SORT and we sorted by the date, but it sorted by the day and not by the year, for example:
01/02/2016
01/03/2017
01/04/2016
01/04/2017
01/05/2016
01/02/2016
01/03/2017
01/04/2016
01/04/2017
01/05/2016
- Attachments
-
- Screenshot
OpenOffice 3.1 on Windows 10
Re: Date Sort Column Rows
The sorting seems incorrect because the information is text, not numeric, which is what Calc uses for dates.
To get it to sort the way you want, first you have to convert your "dates" into numbers, as described to you by Lupp
After you have done the conversion(s) you can use the sorting method you described to get correct results.
As to attaching a file greater than 128k, the only option is to upload it to an online file sharing service (eg: MediaFire, Dropbox, Google Drive), and post a link in the forum to the uploaded file.
To get it to sort the way you want, first you have to convert your "dates" into numbers, as described to you by Lupp
After you have done the conversion(s) you can use the sorting method you described to get correct results.
As to attaching a file greater than 128k, the only option is to upload it to an online file sharing service (eg: MediaFire, Dropbox, Google Drive), and post a link in the forum to the uploaded file.
OpenOffice 4.1.7, LibreOffice 7.0.1.2 on Windows 7 Pro, Ultimate & Windows 10 Home (2004)
If you believe your problem has been resolved, please go to your first post in this topic, click the Edit button and add [Solved] to the beginning of the Subject line.
If you believe your problem has been resolved, please go to your first post in this topic, click the Edit button and add [Solved] to the beginning of the Subject line.