同上空白 (9124)

E2{=IF(INDEX(B:B,RIGHT(SMALL(MATCH(B$2:B$16,B$2:B$16,)/1%+ROW($2:$16),ROW(A1)),2))=LOOKUP(1,0/(E$1:E1<>""),E$1:E1),"",INDEX(B:B,RIGHT(SMALL(MATCH(B$2:B$16,B$2:B$16,)/1%+ROW($2:$16),ROW(A1)),2)))

F2{=INDEX(C:C,RIGHT(SMALL(MATCH(B$2:B$16,B$2:B$16,)/1%+ROW($2:$16),ROW(A1)),2))