I am preparing a dataset for analysis. It's a calendar of a sort, each cell representing a month over the course of 3 1/2 years. Each row is a subject's record. Using another dataset, I have already determined that each subject with 6 or more contiguous cells populated with data conform to a normal distribution.

I have an array of cells 42 cells wide and 2993 rows long. Each row is a distinct record. The maximum count of populated cells in any row (of 42) is 18 cells and the minimum count is 1.

I need to identify each row (of 2993) having a 6 or greater count of CONSECUTIVE, non-blank cells, that count of consecutive non-blank cells, and the first cell in that sequence of non-blank cells (two products.) If a row has more than one series of consecutive non-blank cells, I want the longer or longest of those series on that row.

I need help trying to accomplish this. Any suggestions?