Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have a spreadsheet with the following column headings:
Name Occupation Start Date Termination Date The issue that I'm having is that I'm trying to sort by the termination date. Not all employees have a termination date so therefore their row is blank. I need excel to be able to sort by termination date but I also need it to place all people that have a termination date at the bottom of the spreadsheet. I tried to sort by the termination date but it's doing the opposite of what I would like. It places all that have a date at the top followed by the blanks. Is there something that I can do to solve this issue? Thanks for your help |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I sort data in multiple columns by date in one column? | Excel Discussion (Misc queries) | |||
sort by two columns ends up with wrong sort in 2nd col | Excel Discussion (Misc queries) | |||
Sort command does not sort some columns? | New Users to Excel | |||
data sort is not including all columns in sort | Excel Discussion (Misc queries) | |||
DATE SORT BY COLUMNS | Excel Worksheet Functions |