重複數字 提取 (10532)


E2:G6=TRIM(MID(SUBSTITUTE(A$2,".",REPT(" ",99)),ROW(A1)*99-98,99))


I2:I6{=IFERROR(SMALL(IF((COUNTIF(E$2:G$6,E$2:G$6)>1)*(E$2:G$6<>"")*(COUNTIF(I$1:I1,E$2:G$6)=0),E$2:G$6*1),1),"")


留言