項目多數字 各別取出 (13436)

E2:E8{=INDEX(A:A,RIGHT(SMALL(MATCH(A$2:A$8,A:A,)/1%+ROW($2:$8),ROW(A1)),2))

F2:F8{=INDEX(B:B,SMALL(IF(A$2:A$8=E2,ROW($2:$8)),COUNTIF(E$2:E2,E2)))

G2:J8{=IFERROR(-LOOKUP(1,-MID(SUBSTITUTE(INDEX($C:$C,SMALL(IF($A$2:$A$8=$E2,ROW($2:$8)),COUNTIF($E$2:$E2,$E2))),G$1&":",REPT(" ",99)),99,ROW($1:$99))),"")






留言