查找编号并罗列出来 (10143)


E2:E13{=INDEX(B:B,SMALL(IF(COUNTIF(E$1:E1,B$2:B$17)=0,ROW($2:$17),99),1))&""


F2:H13=LOOKUP(COLUMN(A1)-1,COUNTIF(OFFSET($B$1,,,ROW($1:$99)),$E2),$C$2:$C$99)&""


留言