Not really sure how to describe the problem I have.
I have a set of data with dates and times in column A and values in column B.
The dates and times columns are in this format: 02.11.2009 09:00:00.000 GMT-0000
What I'd like is a way to look through each time and date stamp and when it finds 09:00 in the string to return the maximum values from the 07:00, 08:00 and 09:00 rows in column B.
I have attached an example.
Thanks,
Luke
Bookmarks