I need a formula (not a macro) so as to find the maximum number of blank
rows, appearing between text entries found between rows 1 & 100.
This, in refference to column A.
Ex:

Column A
Row 1 DATA
Row 2
Row 3 DATA (1 Blank cell appeared)
Row 4
Row 5
Row 6 DATA (2 Blank cells appeared)


So, in this case, I'd need for a formula to tell me that the
maximum number
of blank cells appearing between Row 1 & Row 6= 2.
Remember that any non blank cells appearing in column A will
contain text,
not numbers.