Yahoo奇摩 網頁搜尋

  1. ...可以不寫公式沒差 H5公式=INDEX($A$2:$A$25, MATCH (0,COUNTIF($H$4:$H4,$A$2:$A$25),0)) 打完按...

  2. ...,$G:$H,2,0)=C3,INDEX($F:$F, MATCH (B3,$G:$G,0),1),IF(VLO OKUP(B3...

  3. 如果資料從A2開始 =CHOOSE(IFERROR( MATCH ($A2,{"正","負"},0),3),COUNTIF($A$2:$...