![]() |
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 |
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