连续三次升高

 

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

函数公式解决：

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