E2:E22公式下拉:
=INDEX(C:C,RIGHT(SMALL(IF(COUNTIF(B$2:B$10,C$2:C$22),23,ROW($2:$22))+LOOKUP(ROW($2:$22),{2,12,19})/1%
,ROW(A1)),2))&""
E26:E46公式下拉:
=INDEX(C:C,RIGHT(SMALL(IF(COUNTIF(B$26:B$34,C$26:C$46),47,ROW($26:$46))+LOOKUP(ROW($26:$46),{26,36,43})/1%
,ROW(A1)),2))&""