E2{=INDEX(B:B,RIGHT(LARGE(IF(COUNTIF(OFFSET(B$2,,,ROW($1:15)),B$2:B16)=COUNTIF(B:B,B$2:B16),SUMIF(B:B,B$2:B16,C:C)/1%+ROW($2:16)),ROW(A1)),2))&""
另解{=IFERROR(INDEX(B:B,RIGHT(LARGE(IF(MATCH(B$2:B$16,B:B,)=ROW($2:$16),MMULT(N(B$2:B$16=TRANSPOSE(B$2:B$16)),C$2:C$16)/1%+ROW($2:$16)),ROW(A1)),2)),"")
另解E2=LOOKUP(1,0/FREQUENCY(-9^9,-(SUMIF(B:B,B$2:B16,C:C)+1/ROW($2:16))*(COUNTIF(E$1:E1,B$2:B16)=0)),B$2:B16)&""
F2=IF(E2="","",SUMIF(B:B,E2,C:C))
留言
張貼留言