EXCEL统计数字大于0在一行中连续出现的最大次数,用数组公式求的,怎么...答:=SUM(OFFSET(A1,MATCH(MAX(FREQUENCY(IF(A1:A12>0,ROW(A1:A12)),IF(A1:A12>0,,ROW(A1:A12))),FREQUENCY(IF(A1:A12>0,ROW(A1:A12)),IF(A1:A12>0,,ROW(A1:A12))),)-MAX(FREQUENCY(IF(A1:A12>0,ROW(A1:A12)),IF(A1:A12>0,,ROW(A1:A12))...
Excel 如何自动统计, 567分别连续出现多少次?答:B1:=IF(OR(A1={5,6,7})*AND(A2<>{5,6,7}),ROW()-IFERROR(LOOKUP(1,0/((A$1:A1<>5)*(A$1:A1<>6)*(A$1:A1<>7)),ROW($1:1)),),"")下拉