问题:找出连续三次升高的数据
函数公式解决:
{=IF(FREQUENCY(IF(C3:C145>C2:C144,ROW(3:145)),IF(C3:C145>C2:C144,,ROW(3:145)))=3,"连续三次","")}
officeplayer 2022-04-09 19:17 原文
问题:找出连续三次升高的数据
函数公式解决:
{=IF(FREQUENCY(IF(C3:C145>C2:C144,ROW(3:145)),IF(C3:C145>C2:C144,,ROW(3:145)))=3,"连续三次","")}