EXCEL统计数字大于0在一列中连续出现的次数答:第一个数:=MAX(FREQUENCY(IF(A1:A100>100,ROW(A1:A100)),IF(A1:A100>100,,ROW(A1:A100)))第二个数:=LARGE(FREQUENCY(IF(A1:A100>100,ROW(A1:A100)),IF(A1:A100>100,,ROW(A1:A100))),2)如果要得到连续大于110的个数之和,则:=SUM(FREQUENCY(IF(A1:A100>100,ROW(A1:A100)),IF...
excel问题,假设某一列有n个数据,如何统计某个数值连续出现2次的次数...答:可以if()和and()来判断单元格是不是符合要求,公式:=IF(AND(A1<>A2,A2=A3,A3<>A4),1,0)=IF(AND(A1<>A2,A2=A3,A3=A4,A4<>A5),1,0)