连续三次升高


问题:找出连续三次升高的数据

函数公式解决:

{=IF(FREQUENCY(IF(C3:C145>C2:C144,ROW(3:145)),IF(C3:C145>C2:C144,,ROW(3:145)))=3,"连续三次","")}

相关