Search that ignores cells conditionally.

[JamieGoetz]

I need to search down the cars column for separate instances of equal to or greater than 2 that do not occupy the same 60min time frame. As you see below, it would return a no in D2, a Yes in D3 and then must ignore C4, C5 & C6 because they are within 60 minutes of the first instance of 2 cars.

A	B	C	D	E
1	Time	Cars
2	12:00	1	No
3	12:15	2	Yes
4	12:30	2	N/A
5	12:45	3	N/A
6	13:00	1	N/a
7	13:15	1	No
8	13:30	2	Yes
9	13:45	1	N/A
10	14:00	2	N/A

<tbody>
</tbody>

 

[JamieGoetz]

As a follow up, I am using Excel 2010 on Windows 7.