C3:C7{=IFERROR(INDEX(A:A,MATCH(,0/OFFSET(A$1,MAX(SMALL(IF(A$2:A$21=C$2,ROW($1:$20),99),ROW(A1))),,9),)+SMALL(IF(A$2:A$21=C$2,ROW($1:$20),99),ROW(A1))),"")
D3:E7=IFERROR(IF(COUNTIF(OFFSET($A$1,,,MATCH($C3,$A:$A,)),D$2)=ROW(A1)-SUMPRODUCT(N(D$2:D2="")),OFFSET($A$1,MATCH($C3,$A:$A,)+(D$2=$E$2)-(C3=""),),""),"")
留言
張貼留言