Sorting Sorting Sorting

[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

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

--
Regards,
Fred


"Skydiver" <[email protected]> wrote in message
news:[email protected]...
>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

[Skydiver]

It worked. Thanks Jim.

"Jim Cone" wrote:

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

[Skydiver]

It worked. Thanks Fred.

"Fred Smith" wrote:

> 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.
>
> --
> Regards,
> Fred
>
>
> "Skydiver" <[email protected]> wrote in message
> news:[email protected]...
> >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
>
>
>