E3:E8{=IFERROR(INDEX(B:B,RIGHT(LARGE(IF(MATCH(B$2:B$15,B:B,)=ROW($2:$15),MMULT(N(B$2:B$15=TRANSPOSE(B$2:B$15)),C$2:C$15)/1%+ROW($2:$15)),ROW(A1)),2)),"")
F3:F8=IF(E3="","",SUMIF(B:B,E3,C:C))
H3{=INDEX(B:B,MIN(IF(COUNTIF(H$2:H2,B$2:B$15)=0,ROW($2:$15),99)))&""
留言
張貼留言