mombo
New Member
- Joined
- Sep 15, 2017
- Messages
- 7
Using Excel 97, I made a spreadsheet that has groups of names and other information. Each group is preceded by a single row in the group having a date.
This is an example of the organization:
<!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:Compatibility> <w:BreakWrappedTables/> <w:SnapToGridInCell/> <w:WrapTextWithPunct/> <w:UseAsianBreakRules/> </w:Compatibility> <w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel> </w:WordDocument> </xml><![endif]-->
<tbody>
</tbody>
The dates are entered as a string of numbers, and the cells are formatted to display as shown.
How can I sort the groups by date?
This is an example of the organization:
<!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:Compatibility> <w:BreakWrappedTables/> <w:SnapToGridInCell/> <w:WrapTextWithPunct/> <w:UseAsianBreakRules/> </w:Compatibility> <w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel> </w:WordDocument> </xml><![endif]-->
Date | Name | Location | Status |
2017 - 04/13 | John | Boston | active |
David | Chicago | off | |
Paul | Detroit | active | |
Steven | Dallas | active | |
Richard | Miami | off | |
2017 - 02/15 | Donald | Boston | off |
Anthony | Providence | off | |
Walter | Seattle | active | |
Robert | Dallas | off | |
2017 - 08/26 | Peter | New York | active |
Charles | Orlando | active | |
Benjamin | Sacramento | off | |
Victor | Hartford | off | |
Jason | DC | off |
<tbody>
</tbody>
The dates are entered as a string of numbers, and the cells are formatted to display as shown.
How can I sort the groups by date?