ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Sorting data by Date (https://www.excelbanter.com/excel-worksheet-functions/55099-sorting-data-date.html)

Mark F.

Sorting data by Date
 
I have a sheet in with several columns. In each of the columns are two
text cells and a data/time cell. I want to know how to sort the sheet so
that the columns appear sorted by date with the earliest to latest. The
columns are laid out like this:

C D E F etc...
1 String String String String
2 Date Date Date Date
3 String String String String

Thanks.
Mark

Jezebel

Sorting data by Date
 
Select the columns. Click Data Sort. On the Sort dialog click Options and
select 'Left to right'. Then select Row 2 to sort by.





"Mark F." wrote in message
...
I have a sheet in with several columns. In each of the columns are two text
cells and a data/time cell. I want to know how to sort the sheet so that
the columns appear sorted by date with the earliest to latest. The columns
are laid out like this:

C D E F etc...
1 String String String String
2 Date Date Date Date
3 String String String String

Thanks.
Mark





All times are GMT +1. The time now is 07:50 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com