Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I sort nulls within date field in Excel
When I attept to sort a date column, either ascending or descending, the
dates always sort at the top. Is there code or a way to sort to produce a result that the nulls (blank dates) within the column will appear at the top of the column and the dates will folow in ascending order below the nulls? Any help is greatly appreciated. thank you. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I sort nulls within date field in Excel
Maybe you could just sort, then move them where you want.
Or fill the empty cells with 0's. sort your dates/0's replace all the 0's with nothing (Match entire cell contents, though) Petra wrote: When I attept to sort a date column, either ascending or descending, the dates always sort at the top. Is there code or a way to sort to produce a result that the nulls (blank dates) within the column will appear at the top of the column and the dates will folow in ascending order below the nulls? Any help is greatly appreciated. thank you. -- Dave Peterson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I sort nulls within date field in Excel
Hi,
I do not have a complete answer, but I belive it can be done with "lists", where a list is created and used as the sort order. Maybe one of the MVPs can help further, but that was as close as I could get. You might try help and "lists" to see if you can define the sort in a better way. Thanks, "Petra" wrote: When I attept to sort a date column, either ascending or descending, the dates always sort at the top. Is there code or a way to sort to produce a result that the nulls (blank dates) within the column will appear at the top of the column and the dates will folow in ascending order below the nulls? Any help is greatly appreciated. thank you. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I sort a column in Excel by the last digit in each field | Excel Discussion (Misc queries) | |||
how do i sort formated (colour) field in excel? | Excel Discussion (Misc queries) | |||
how do i sort formated (colour) field in excel? | Excel Discussion (Misc queries) | |||
How to Join/concatenate a date field with a time field in Excel? | Excel Discussion (Misc queries) | |||
Using Excel, how do I replace cells containing blanks with nulls? | Excel Discussion (Misc queries) |