判斷最后4天節節高升 (9016)

I2{=REPT("达标",IFERROR(AND(OFFSET(A2,,COUNTA(A2:H2)-1,,-3)-OFFSET(A2,,COUNTA(A2:H2)-2,,-3)>=0),))

另解=REPT("达标",IFERROR((COUNTA(A2:H2)-LOOKUP(1,0/(B2:H2<A2:G2)/(B2:H2<>""),COLUMN(B:H))>2),1)*(COUNTA(A2:H2)>3))

另解{=IFERROR(IF(AND(MMULT({1,-1},N(OFFSET($A2,,COUNT(A2:H2)-{3,2,1}+{0;-1})))>=0),"达标",""),"")

格式化 B2:H16=(B2>=A2)*(B2<>"")