- ©«¤l
- 812
- ¥DÃD
- 7
- ºëµØ
- 0
- ¿n¤À
- 862
- ÂI¦W
- 0
- §@·~¨t²Î
- XP
- ³nÅ骩¥»
- 2007
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¤¤
- µù¥U®É¶¡
- 2010-5-13
- ³Ì«áµn¿ý
- 2019-10-10

|
FÄæ¥ý³]©w¬°¦Û°Ê´«¦æ,¦A¥Î¦Û°Ê´«¦æ²Å¸¹³s±µ
F2=IF(COUNTIF($A$2:$A$15,E2)>1,INDEX(B:B,SMALL(IF($A$2:$A$15=E2,ROW($A$2:$A$15),4^8),1))&CHAR(10)&INDEX(B:B,SMALL(IF($A$2:$A$15=E2,ROW($A$2:$A$15),4^8),2)),INDEX(B:B,SMALL(IF($A$2:$A$15=E2,ROW($A$2:$A$15),4^8),1))&"") |
|