Matrix Help

I have a set of 4 columns with YES/NO statements in them.
I need to find any YES strings, of three or more, within one column, uninterupted by a YES in another colum.

EXAMPLE:
_____A ___B__C__D__E
1 1/1/2008 YES NO NO NO
2 1/2/2008 NO NO YES YES
3 1/3/2008 YES NO NO NO
4 1/4/2008 YES NO NO NO
5 1/5/2008 NO NO NO NO
6 1/6/2008 YES NO NO NO

B1:B4 would not meet this criteria because D2 and E2 fall in the middle of this yes string.

B3:B6 would meet this criteria. Any set of numbers that do meet this criteria need to be recorded with the last date that string falls on, the number of uninterupted YES's in that string, and the catagorie it falls under.

In this example, I need something like:
DATE_________No of Occurences/Catagorie
1/6/2008_______________3B


After multiple entries, it would look something like this:
1/ 6/2008______________3B
1/13/2008______________3A
1/19/2008______________3D
2/ 4/2008______________4C

Can something like this be done?