排名 依同姓名同日期總數值

E2:F11{=IFERROR(INDEX(A:A,RIGHT(LARGE(IF(MATCH($A$2:$A$20&$B$2:$B$20,$A$2:$A$20&$B$2:$B$20,)=ROW($1:$19),SUMIFS($C:$C,$A:$A,$A$2:$A$20,$B:$B,$B$2:$B$20)/1%+ROW($2:$20)),ROW(A1)),2)),"")

G2:G11=IF(E2="","",SUMIFS(C:C,A:A,E2,B:B,F2))



留言