判断连续4个样本大于 小于0.5 (8882)

A7:H7=IF(MAX(FREQUENCY(ROW(1:6),(A1:A5<0.5)*ROW(1:5)))>4,"A",IF(MAX(FREQUENCY(ROW(1:6),(A1:A5>0.5)*ROW(1:5)))>4,"B",""))