View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Skydiver
 
Posts: n/a
Default Sorting Sorting Sorting

It worked. Thanks Fred.

"Fred Smith" wrote:

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

--
Regards,
Fred


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