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

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - how do I sort a column of random dates into Consecutive dates (https://www.excelbanter.com/excel-worksheet-functions/146108-how-do-i-sort-column-random-dates-into-consecutive-dates.html)

Rob Gibson

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

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?

Gord Dibben

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

DataSortDescending.

Gord Dibben MS Excel MVP

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

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?

Max

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

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.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Rob Gibson" wrote:
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?

All times are GMT +1. The time now is 06:27 PM.