| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting Sorting Sorting
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sorting Sorting Sorting
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" 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sorting Sorting Sorting
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sorting Sorting Sorting
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" 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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Maintaining cell reference after sorting | Excel Discussion (Misc queries) | |||
| Sorting Data in ascending order | Excel Discussion (Misc queries) | |||
| sorting non contiguous ranges | Excel Discussion (Misc queries) | |||
| Advice sought: Multiple column sorting | Excel Worksheet Functions | |||
| Sorting 1, 1A, 2, 2A, 3, 4, 4A, 4B . . . | Excel Discussion (Misc queries) | |||
Linear Mode
