Hi Guys
I hope there's an excel genius out there that can help me with this one!?
I've attached a spreadsheet which shows a diary broken down by the date (in each column) and the time by half hour (in the row). I work on various projects and want to automatically calculate, using formula, when each project (or project code) first appears (time and date) and when it last appears (time and date). I've provided some dummy data and an example of what i need returned.
I hope this makes sense and also hope that someone can help me find a simple solution!
Cheers!
Bookmarks