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

R

Rob Gibson

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?
 
G

Gord Dibben

Data>Sort>Descending.


Gord Dibben MS Excel MVP

On Mon, 11 Jun 2007 20:54:00 -0700, Rob Gibson <Rob
 
M

Max

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.
 
Top