åæä¸è¡æ²¡æé®é¢ï¼ä½æ¯åæä¸ä¸ªåå
æ ¼é¾åº¦æ¯è¾å¤§ï¼å个ä¸è¡çä¾ä½ åè
详è§æ ·è¡¨æªå¾
E1è¾å ¥
=INDEX($B:$B,SMALL(IF($A$1:$A$20=$C1,ROW($1:$20),1000),COLUMN(A1)))&""
æ°ç»å ¬å¼ï¼å æä½ctrl+shift,æåå车
å ¬å¼å³æä¸æ
ä¸ç¥å¯¹ä½ æ¯å¦æ帮å©
为ä»ä¹æ¯è¿æ ·ãããã
ä¸å¼æºæ¢°å¥ç¨åï¼ä½ çåè·ææ ·è¡¨ä¸ä¸æ ·å
ä½ çåºè¯¥æ¹æ
INDEX($C:$C,SMALL(IF($B$2:$B$100=$D1,ROW($2:$100),1000),COLUMN(A1)))&""