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.



[TABLE="class: grid, width: 300, align: left"]
<tbody>[TR]
[TD="align: center"]A[/TD]
[TD="align: center"]B[/TD]
[TD="align: center"]C[/TD]
[TD="align: center"]D[/TD]
[TD="align: center"]E[/TD]
[/TR]
[TR]
[TD="align: center"]1[/TD]
[TD="align: center"]Time[/TD]
[TD="align: center"]Cars[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]2[/TD]
[TD="align: center"]12:00[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]No[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]3[/TD]
[TD="align: center"]12:15[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]Yes[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]4[/TD]
[TD="align: center"]12:30[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]N/A[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]5[/TD]
[TD="align: center"]12:45[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]N/A[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]6[/TD]
[TD="align: center"]13:00[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]N/a[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]7[/TD]
[TD="align: center"]13:15[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]No[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]8[/TD]
[TD="align: center"]13:30[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]Yes[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]9[/TD]
[TD="align: center"]13:45[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]N/A[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]10[/TD]
[TD="align: center"]14:00[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]N/A[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
</tbody>[/TABLE]

 

[JamieGoetz]

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