客戶不重複 總量排名 (1-15057)

E2:E6{=IFERROR(INDEX(B:B,RIGHT(LARGE(IF(MATCH(B$2:B$16,B:B,)=ROW($2:$16),SUMIF(B:B,B$2:B$16,C:C)/1%%+ROW($2:$16)),ROW(A1)),2)),"")

F2:G7=IF($E2="","",SUMIF(B:B,E2,C:C))