Sorting Sorting Sorting

[Guest]

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

 

[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

 

[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.

 

[Guest]

It worked. Thanks Fred.

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.

 

[Guest]

It worked. Thanks Jim.