- ©«¤l
- 976
- ¥DÃD
- 7
- ºëµØ
- 0
- ¿n¤À
- 1018
- ÂI¦W
- 0
- §@·~¨t²Î
- Win10
- ³nÅ骩¥»
- Office 2016
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2013-4-19
- ³Ì«áµn¿ý
- 2024-10-30
|
¦^´_ 3# fantersy
JÄæÀx¦s®æ§ï¬°¦Û°Ê´«¦C¡A
J2=IF(SUMPRODUCT((®w¦s¹wpª¬ªp!$A$1:$A$3768=D2)*(®w¦s¹wpª¬ªp!D1:D3768="»â¥Î")),IFERROR(INDEX(®w¦s¹wpª¬ªp!$H:$H,SMALL(IF((®w¦s¹wpª¬ªp!$A$1:$A$3768=$D2)*(®w¦s¹wpª¬ªp!$D$1:$D$3768="»â¥Î"),ROW($A$1:$A$3768),""),1))&CHAR(10)&INDEX(®w¦s¹wpª¬ªp!$H:$H,SMALL(IF((®w¦s¹wpª¬ªp!$A$1:$A$3768=$D2)*(®w¦s¹wpª¬ªp!$D$1:$D$3768="»â¥Î"),ROW($A$1:$A$3768),""),2)),""),"")
J2°}¦C¤½¦¡
¤W±¬õ¦âªº1¬O²Ä¤@µ§¸ê®Æ¡A2¬O²Ä¤Gµ§¸ê®Æ¡A
1&CHAR(10)&2&CHAR(10).... ¡A
¦p¦³»Ýn§ó¦hµ§½Ð¦Û¦æÂX¥R
¨ä¹ê¼Ï¯Ã¤ÀªR¤]¥i¥H |
|