不重複排列 依指定顺序 (11105)

E2{=IFERROR(INDEX(B:B,RIGHT(SMALL(IF(MATCH(B$2:B$99&"",B$2:B$99&"",)=ROW($1:$98),MATCH(B$2:B$99&"",H:H&"",)/1%+ROW($2:$99)),ROW(A1)),2))&"","")

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