查找各单位所有姓名 (8982)

E2{=INDEX(C:C,RIGHT(SMALL(MATCH(C$2:C$16,{"A","B","C","D","E"},)/1%+ROW($2:$16),ROW(A1)),2))

F2{=INDEX(B:B,SMALL(IF(C$2:C$16=E2,ROW($2:$16)),COUNTIF(E$2:E2,E2)))