æ©å 天é£ä¸ªä¸ä¸ªæ¡ä»¶çéçé®é¢ä¹æ¯ä½ æçé®å§ï¼çé®é¢çå 容æç¸ä¼¼ï¼æªå¾é£æ ¼ï¼é®é¢æ§è´¨ä¹åºæ¬ç¸åãå 为ç°å¨ç¾åº¦ç¥éä¸æ æ³çå°æé®è çIDäºï¼æ以ä¸è½ç¡®å®ã
æ¬é®é¢åé£ä¸ªé®é¢åºæ¬å·®ä¸å¤ï¼ä½å 为å¢å äºä¸ä¸ªæ¡ä»¶ï¼å½ç¶è¦å¤æäºäºï¼å¦å¾ï¼å¨A14å¼å§è·å符åæ¡ä»¶çåºå·ï¼
=INDEX($A$5:$A$10,SMALL(IF((OFFSET($A$5:$A$9,,MATCH($B$1,$B$4:$D$4,))=$B$1)*(OFFSET($A$5:$A$9,,MATCH($B$2,$B$4:$G$4,))=$B$2),ROW($1:$5),6),ROW(1:1)))&""
åæ¶æCtrl+Shift+Enterä¸é®è¾å ¥æ°ç»å ¬å¼
å ¶å®å 为A5:A9æ¯èªç¶æ°çåºåå·ï¼å ¬å¼è¿å¯ç¨ç®åç¹ï¼ä½ä¸é¢çå ¬å¼å¯ä»¥å¨Aåä¸æ¯é¡ºåºçèªç¶æ°ä¹ä¸æ ·è½ååºæ¥ï¼æ以è¿æ¯è¿ä¸ªå ¬å¼å¥½äºã
B14=IFERROR(INDEX($B$5:$G$10,MATCH(--$A14,$A$5:$A$10,),MATCH(B$13,$B$4:$G$4,))&"","")
å³æå°G14ï¼éæ©A14:G14ï¼ä¸èµ·ä¸æå°ç¬¬18è¡ï¼å ±5è¡ââä¿è¯ç¬¬5è¡å°ç¬¬9è¡5è¡æ°æ®é½ç¬¦åè¦æ±æ¶ï¼æè½ååºï¼
ä¸é¢æ¯B1ãB2éæ©ä¸åæ°æ®æ¶ï¼ç¬¬14è¡å¼å§æ¾ç¤ºçéåçç»æï¼æ»¡è¶³é¢ä¸»çè¦æ±
追é®å¤è°¢é«ææç¹ï¼é常æè°¢ï¼