matlab challenge- searching range of data to see if certain values exist

http://i52.tinypic.com/264gsnn.jpg

please see the abov elink for a visual of my issue.. basically the values in the 3rd and 4th columns exist because there was an update. this is also because of both of the values of "0" in the 7th and 8th columns one row down. i need to be able to search a document for all instances where either of these occur, and i wanted to do this by choosing an interval time range of data from the 1st column and seeing if these values are what i am looking for. keep in mind that the actual data i have is long and there will be about 40 different cases of this. the end goal is to figure out all the times where this update occurs. any idea how to tackle this?? i am so stuck and any help at all would be much appreciated. thanks in advance.

Answer 1

[Oleg Komarov]

1. Import the file with xlsread (is that an xlsx?)
2. Convert dates into serial dates
3. Use logical indexing/ismember to locate the range of interest
4. Again use logical indexing on 3rd and 4th column