F2{=IFERROR(INDEX(B:B,RIGHT(LARGE(IF(MATCH(B$2:B$16,B:B,)=ROW($2:$16),D$2:D$16/1%+ROW($2:$16)),ROW(A1)),2)),"")
G2=IF(F2="","",VLOOKUP(F2,B:D,3,))
I2{=IFERROR(INDEX(B:B,RIGHT(LARGE(IF(MATCH(B$2:B$16,B:B,)=ROW($2:$16),MMULT(N(B$2:B$16=TRANSPOSE(B$2:B$16)),C$2:C$16)/1%+ROW($2:$16)),ROW(A1)),2)),"")
留言
張貼留言