用VLOOKUP函數的公式,我們也在F2儲存格輸入陣列公式:「=IF(COUNTIF(A$2:A$11,D$2) <ROW(A1),"",VLOOKUP(D$2&ROW(A1),IF({1,0},A$2:A$11&COUNTIF(INDIRECT("A2:A"& ROW($2 ...
確定! 回上一頁