Sorting a column with a variable number of entries

[jsswansonjr]

[FONT=Arial, sans-serif]Each individual listed in a spread sheet would have a column titled "not available", which contains dates throughout the year that they are not available for work assignments. I need to sort this column in order to know which dates different individuals are not available. A given individualcould have the following dates that they are not available, June 1^stthrough June 25th, July 15^ththrough August 10^thand September 2nd through November 5^th. Individuals entered into the spread sheet could have none or multiple entries in the “not available” column. What wouldbe the best way to set-up this up and then sort the column? Thanks[/FONT]

 

[FDibbins]

Probably by name, and then by date in that column? (assuming you have REAL dates in that column?)