不重複數據 提取 (14845)

D2{=INDEX(B:B,MIN(IF(COUNTIF(D$1:D1,B$2:B$16)=0,ROW($2:$16),99)))&""

E2=COUNTIF(D:D,"><")-1

計算數量 直接用數據欄=SUMPRODUCT(1/COUNTIF(B:B,B2:B16))