Sorting dates and keeping the sequence correct?
Posted by Dominic on March 28, 2001 11:47 PM
Dez 00 695,00 DM 695,00 DM
Nov 00 686,00 DM 686,00 DM
Okt 00 669,00 DM 669,00 DM
Sep 00 657,00 DM 657,00 DM
Aug 00 652,00 DM 652,00 DM
Jul 00 638,00 DM 646,00 DM
Jun 00 636,00 DM 636,00 DM
Mai 00 628,00 DM 628,00 DM
Apr 00 624,00 DM 624,00 DM
Mrz 00 616,00 DM 616,00 DM
Feb 00 606,00 DM 606,00 DM
Jan 00 597,00 DM 597,00 DM
Dez 99 587,00 DM 587,00 DM
Nov 99 576,00 DM 576,00 DM
I have a selection of data from Jan 01 through to Dec 92, I now want to show the data from Dec 92 to Jan 01, if I do a normal sort I end up with all the Jans together and then the febs etc. I want to keep them in month/year sequence but have them sorted oldest date to newest date.How do I do it?
Posted by Edgar on March 29, 2001 2:56 AM
Posted by Edgar on March 29, 2001 2:59 AM
Try formatting your date column as Date.
Posted by Dominic on March 29, 2001 4:15 AM
Problem resolved
I solved the problem by converting the date format to numerical ie 01.01.2000 and then sorted . This way they remained in sequence.
Posted by Mark W. on March 29, 2001 11:21 AM
Dominic, using a new column enter the formula,
=A1+0, where A1 is your first date value listed
below. Copy this formula down to the last row
of your data set. Sort on this new datevalue.
