降冪 去重複 (9835)


E2:G7{=IFERROR(LARGE(IF((MATCH($B$2:$B$16&$C$2:$C$16,$B$2:$B$16&$C$2:$C$16,)=ROW($1:$15))*($B$2:$B$16=E$1),$C$2:$C$16),ROW(A1)),"")


留言