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?

This macro might help. It seems to be easier to start at the bottom and work upwards.

Please Login or Register  to view this content.

You can then sort your data by date.

Purely as a heads up (given resolved) given changes made in 2007 it's now best to use Rows.Count as opposed to 65536:

eg this:

Please Login or Register  to view this content.

as opposed to this:

Please Login or Register  to view this content.

This is purely down to the fact that 2007 has 1 million plus rows and thus you can not guarantee 100% of the time that the 65536 method will work pending version etc.... the Rows.Count method is essentially failsafe
(the same is true re: Columns.Count etc...)