D3{=INDEX(A:A,RIGHT(MAX(IF(COUNTIF(D$2:D2,A$3:A$16)=0,SUMIF(A:A,A$3:A$16,B:B)/1%+ROW($3:$16))),2))&""
另解{=INDEX(A:A,RIGHT(MAX(IF(COUNTIF(D$2:D2,A$3:A$15)=0,SUMIF(A:A,A$3:A$15,B:B)/1%+ROW($3:$15),99)),2))&""
另解{=INDEX(A:A,RIGHT(LARGE(IF(MATCH(A$3:A$15,A:A,)=ROW($3:$15),SUMIF(A:A,A$3:A$15,B:B)/1%+ROW($3:$15),99),ROW(A1)),2))&""
E3=IF(D3="","",SUMIF(A:A,D3,B:B))
留言
張貼留言