how do I sort a column of random dates into Consecutive dates

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Rob Gibson - 12 Jun 2007 04:54 GMT

I have a long column of random dates that need to be in order from oldest to
newest. How do I accomplish this in excel?

Reply to this Message

Gord Dibben - 12 Jun 2007 05:02 GMT

Data>Sort>Descending.

Gord Dibben MS Excel MVP

>I have a long column of random dates that need to be in order from oldest to
>newest. How do I accomplish this in excel?

Reply to this Message

Max - 12 Jun 2007 05:10 GMT

Assuming these are real dates which are frozen values (and not formulas
containing RAND()), then just sort ascending on the dates col should do it
for you.

Signature

Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

> I have a long column of random dates that need to be in order from oldest to
> newest. How do I accomplish this in excel?

Reply to this Message