小於等於與等於 一公式取資料 (14149)

G5:H9{=INDEX($D:$D,MIN(IF((COUNTIF(G$4:G4,$D$3:$D$17)=0)*INDEX(COUNTIF($H$2,{">=","="}&$B$3:$B$17),,COLUMN(A1)),ROW($3:$17),4^8)))&""

另解{=INDEX($D:$D,MIN(IF((COUNTIF(G$4:G4,$D$3:$D$17)=0)*CHOOSE(COLUMN(A1),{1,0},{0,1})*COUNTIF($H$2,{">=","="}&$B$3:$B$17),ROW($3:$17),4^8)))&""