F2:F5{=INDEX(B:B,RIGHT(LARGE(IF(MATCH(B$2:B$16,B:B,)=ROW($2:$16),RIGHT(SMALL((TRANSPOSE(B$2:B$16)=B$2:B$16)*TRANSPOSE(D$2:D$16)+ROW($1:$15)/1%%,ROW($1:$15)*15),4)/1%+ROW($2:$16)),ROW(A1)),2))
G2:H5{=INDEX(C:C,RIGHT(MAX(IF($B$2:$B$16=$F2,$D$2:$D$16/1%+ROW($2:$16))),2))
留言
張貼留言