Hey guys, I have a spreadsheet of assignments to students and I wanted to categorize them by assignment start date, and end date for each assignment. The problem is, the person who made the spreadsheet for me didn't organize the dates correctly so Assignment 1 might actually be Assignment 2 because the dates aren't in chronological order right now.
I need to organize everyones info in chronological order for each assignment, and some assignment both start on the same date so the preferable thing to do would be to use the earliest end date as Assignment 1 and the later one as Assignment 2.
In the workbook attached it would be like
Testbook.xlsx
So in this case, John Marks and Bob Marley need to have their two assignment dates switched. Bart Simpson needs to get his assignment end dates switched because the earlier end date was 7/8/10 and the later one was 7/20/10 so the earlier one is Assignment 1 and the later one is Assignment 2.
Some people have more than 5 assignments, and some people only have one.
I tried using conditional formatting to try and find any dates that were less than the first two and sorted through those but I never got any matches probably because my formatting formula was wrong even when dragged down. If anyone has any ideas that'd be awesome!
Bookmarks