Hey guys/girls
I am looking for some inspiration on how to achieve my goal
Basically I have a list of instructions with a start and end time for each like
instruction1 12:00 12:20
I have 5 sets of these and I am trying to find 'clashes' inbetween them, what I was hoping for was something like a data validation list where you select the instruction (ive got this far :-)) and then excel would display all the instructions that also operate at this time.
Is there a simple function to do this? If not could someone point me in the right direction?
I was thinking along the lines of autofilters, but not sure how I would go about implementing a 'between these times' filter.
I am using Excel 2010
Many Thanks
Dave
Bookmarks