max number of non-empty consecutive cells

[mendee525]

Dear all,
How i can find max number of non-empty consecutive cells in a row?

	A	B	C	D	E	F	G	K
1	07:55:24 17:04:47		08:01:57 17:21:42	07:58:30 17:10:32	07:48:49 17:40:45	07:55:51 17:29:54		17:58:13	Result 4
2	08:32:14 20:00:54		07:36:35 20:18:17		07:35:05 20:00:05	07:35:05 20:00:05	08:41:17		Result 3

 

[jasonb75]

This will do it.

Book1 (version 1).xlsb
	A	B	C	D	E	F	G	H	I
1	07:55:24		08:01:57	07:58:30	07:48:49	07:55:51		17:58:13	4
2	08:32:14		07:36:35		07:35:05	07:35:05	08:41:17		3
Sheet6

Cell Formulas
Range	Formula
I1:I2	I1	=MAX(FREQUENCY(IF(A1:H1<>"",COLUMN(A1:H1)),IF(A1:H1="",COLUMN(A1:H1))))
Press CTRL+SHIFT+ENTER to enter array formulas.

It is preferable if you use XL2BB to post any examples to the forum, formatting is often corrupted when you use copy and paste.