è§æªå¾
å å°Aåæ·è´å°Eåï¼éæ©Eå>æ°æ®>å é¤éå¤é¡¹>ç¡®å®
æ¤æ¥éª¤å°±æ¯å°Aåå»é¤éå¤é¡¹ï¼ä¿çå¯ä¸å¼
E1è¾å ¥
=INDEX($B:$B,SMALL(IF($A$1:$A$100=$E1,ROW($1:$100),1000),COLUMN(A1)))&""
æ°ç»å ¬å¼ï¼å æä½CTRL+SHIFT,æåå车
å ¬å¼å³æåä¸æ