在Excel中计算空白单元格前的数字的最大间隔数

is there a way to count, just using formulas, intervals of cells with numbers in a row (before a blank cell appears) and display the value of the "biggest chain" found? I am doing a research about automatization in Twitter. I have a list of n Users. There is one column for each hour of the research, and in every cell there is the number of tweets published for each user during this hour. If a user didn't publish in one specific hour, this cell is empty (here X means an empty cell):is there a way to count, just using formulas, i