æ¬é®é¢å¯èè以ä¸ä¸¤ç§æ¹æ³ä¹ä¸ï¼
æ¹æ³ä¸ï¼æ°æ®éè§è¡¨å textjoinå½æ°æ³ï¼
å æå ¥æ°æ®éè§è¡¨ï¼å¯¹å§ååéå®åç±»åç»å¹¶å¯¹æ°éæ±åï¼ç¶åç¨å ¬å¼æ±åºéå®æ¥èåãéè§è¡¨ä¸æå§åååç±»æå°è¡å段åºåï¼æ°éæçæ±æ»åºåï¼è®¾ç½®æ ¼å¼å°èªå·±éè¦çæ ·åãå¦å¾ï¼æéè§è¡¨æ¾å¨G1å¼å§çåå æ ¼ä¸ï¼éè§è¡¨è®¾ç½®å¥½åï¼åå¨Jåç¨å ¬å¼å¾å°éå®æ¥çèåï¼
J2=TEXTJOIN(",",,IF(A$2:A$6&B$2:B$6=G2&H2,D$2:D$6,""))
ä¸æ
æ¹æ³äºï¼ç¨Power Qureyï¼ä¸æ¬¡å®æï¼æ¨è使ç¨ãå æ ççæ°æ®åºååï¼æ°æ®èåï¼è·åæ°æ®ââä»è¡¨æ ¼æåºåï¼å¼¹åºå¯¼å ¥æ°æ®å¯¹è¯æ¡ï¼ç¡®å®åè¿å ¥Power Qureyï¼å¨PQä¸ï¼åªéè¦ä¸ä¸ªæ¥éª¤å³å¯å®ç°éè¦çææï¼å°±åç»ï¼åç»ä¾æ®ä¸éæ©é«çº§ï¼åæ¶æå§ååç§ç±»ä½ä¸ºåç±»ä¾æ®ï¼å¯¹æ°éè¿è¡æ±åï¼å¯¹éå®æ¥åæ ·å éæ©æ±åï¼åé¢éè¿ä¿®æ¹Mè¯å¥æ¹ä¸ºèåï¼ã ç¡®å®åï¼æ°éå·²æ±åï¼ä½éå®æ¥æ¯ææ¬æ°æ®ï¼æ±åå½ç¶ä¼åºéãå¦å¾ä¿®æ¹ä¸ºææ¬èååå°±å¾å°éè¦ç»æã
å¾ä¸ä¸é¢æ¯æ±åMè¯å¥ï¼ä¸é¢å°±æ¯ä¿®æ¹åçèåãä¸è½½åå·¥ä½è¡¨åï¼ææå¦å¾