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:
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: center"]MAX DATA IN SUCCESSION[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD][/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD="align: center"]3[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD][/TD]
[TD]1[/TD]
[TD][/TD]
[TD="align: center"]2[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD][/TD]
[TD="align: center"]5[/TD]
[/TR]
</tbody>[/TABLE]

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!!