政府發放現金 找每人銀行 (10971)


H2{=IFERROR(INDEX(C:C,RIGHT(LARGE(IF(B$2:B$16=G2,D$2:D$16/1%+ROW($2:$16)),1),2)),"無")


另解{=IFERROR(LOOKUP(1,0/(MAX(IF(B$2:B$16=G2,D$2:D$16))=D$2:D$16)/(B$2:B$16=G2),C$2:C$16),"無")


留言