F2{=INDEX(C:C,SMALL(IF(IFERROR(MATCH(C$2:C$18&1,C$2:C$18&(D$2:D$18>0)*1,)=ROW($1:$17),),ROW($2:$18),99),ROW(A1)))&""
G2:I7{=INDEX($D:$D,SMALL(IF(($C$2:$C$18=$F2)*($D$2:$D$18>0),ROW($2:$18),99),COLUMN(A1)))&""
K2{=SUBSTITUTE(INDEX(C:C,SMALL(IF(D$2:D$18>0,ROW($2:$18),99),ROW(A1)))&"",LOOKUP(1,0/(K$1:K1<>""),K$1:K1),)
L2{=INDEX(D:D,SMALL(IF(D$2:D$18>0,ROW($2:$18),99),ROW(A1)))&""
留言
張貼留言