Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sorting by date and ASAP
Hi all,
I have a Production Monitoring sheet that I sort in various ways - by Customer, by Due date, by Progress% etc, depending on my what I need at the time. I use macros for this. I would like to be able to put ASAP in the date column sometimes, and have those rows sort to the top of the column when I sort by date. At the moment they sort to the bottom. How is it possible that the clever dickies at Microsoft don't know that ASAP comes first, not last? Is there any way to overcome this terrible oversight? (If I enter '1' they will sort to the top, but display a date of 1 Jan 1900, which is a bit off-putting. I would really rather ASAP) Thanks in advance Dave - Kiwi in Brazil |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date Sorting | Excel Worksheet Functions | |||
Sorting by Date | New Users to Excel | |||
sorting by date | Excel Worksheet Functions | |||
sorting date " MMM-YY" (Jan-05) | Excel Discussion (Misc queries) | |||
Sorting by date when the date isn't exact | Excel Discussion (Misc queries) |