Sorting Sorting Sorting

S

Skydiver

I have data in column A & B. Column A contains text and column B contains
mixed dates (years). I want to sort ascending both columns based on the
earliest to latest date. Help.

John
 
J

Jim Cone

John,

Select all of the data that you want to sort.
Go to the Data menu and select Sort.
On the displayed form make sure column B is selected
and that ascending is check marked.
--
Jim Cone (D582)
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware


"Skydiver" <[email protected]>
wrote in message
I have data in column A & B. Column A contains text and column B contains
mixed dates (years). I want to sort ascending both columns based on the
earliest to latest date. Help.

John
 
F

Fred Smith

As long as column B contains true Excel dates, it's a simple Data>Sort...
Specify column B in Sort By, and it will put them in order with the earliest
first.
 
S

Skydiver

It worked. Thanks Fred.

Fred Smith said:
As long as column B contains true Excel dates, it's a simple Data>Sort...
Specify column B in Sort By, and it will put them in order with the earliest
first.
Click to expand...
 
Top