Count Max Number of successive Data in Multiple Rows/Columns

[scowie]

Hello,

I am having issues calculating the maximum number of successive data in an array. I do have the formula for calculating the max number of successive data in a single row.

However, my issue is I want to use that formula and apply it to rows below row 2 and beyond and have it return the maximum number of successive data including all of the rows.

Here is an example if my explanation was unclear:

						MAX DATA IN SUCCESSION
1	1	1		1	1	3
	1	1		1		2
1	1	1	1	1		5

<tbody>
</tbody>

So the formula for calculating the max data in succession for row 2, for example, would be:

=(MAX(FREQUENCY(IF(A2:F2<>"",COLUMN(A2:F2)),IF(A2:F2="",COLUMN(A2:F2))))

From this, I would like to combine the formulas into one and have the formula consider all data (A2:F4) and return the max number of successive data (which would be 5).

Thanks for your help!!