去重排序 指定欄位數 (15388)

B2右拉 下拉{=IF(F$1>$D$2,"",IFERROR(INDEX($B:$B,RIGHT(SMALL(IF(COUNTIF(OFFSET($B$2,,,ROW($1:$98)),$B$2:$B$99)=1,$B$2:$B$99/1%+ROW($2:$99)),(ROW(A1)-1)*$D$2+F$1),2)),""))



留言