连续非0出现次数最多的起止日期 (12009)

A12:I17{=MATCH(1=1,A3:$J3=0,)-1

K3:K8=OFFSET(A$2,,MATCH(MAX(A12:I12),12:12,)-1)

L3:L8=K3+MAX(A12:I12)-1

無輔助 N3:N8 {=INDEX($2:$2,MATCH(MAX(FREQUENCY(ROW($1:$10),(A3:I3=0)*COLUMN(A:I)))-1,RIGHT(SMALL(IF((ROW($1:$10)<=COLUMN(A:J))*(A3:J3=0),COLUMN(A:J),99)+ROW($1:$10)/1%,ROW($1:$10)*10-9),2)-ROW($1:$10),))

無輔助 O3:O8 =N3+MAX(FREQUENCY(ROW($1:$10),(A3:I3=0)*COLUMN(A:I)))-2

K3:K8 連續數字均 1 且高級版本 可=INDEX($2:$2,LOOKUP(99,FIND(REPT(1,ROW($1:$9)),CONCAT(A3:I3))))