Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sorting data by date | Excel Worksheet Functions | |||
Sorting data by date | Excel Worksheet Functions | |||
sorting data in linked worksheets | Excel Discussion (Misc queries) | |||
unwanted number to date conversion while pasting data from web | Excel Worksheet Functions | |||
Autofilter on date fields should refelct the underlying data (rat. | Excel Discussion (Misc queries) |