有重複的值 取不重複值 (12000)

E2:E5{=IFERROR(INDEX(A:A,MATCH(,0/(COUNTIF(A:A,A$2:A$24)>1)/(COUNTIF(E$1:E1,A$2:A$24)=0),)+1),"")

F2:L5{=REPT(F$1,OR(($A$2:$A$24=$E2)*($B$2:$B$24=F$1)))



留言