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))),"")
留言
張貼留言