dragonhsu

¤£ª¾¹D¬O¤£¬O³o¼Ë¤l excel¹ïÀ³¸ê®Æ¤Î¥¼¹ïÀ³¸ê®Æ§e²{.rar (7.88 KB)

¤U¸ü¦¸¼Æ: 5

2015-6-26 17:03

dragonhsu

¬Ý¬Ý¬O§_¦³À°¨ì§A excel¹ïÀ³¸ê®Æ¤Î¥¼¹ïÀ³¸ê®Æ§e²{-1.rar (8.07 KB)

¤U¸ü¦¸¼Æ: 3

2015-6-29 13:36

dragonhsu

¦^´_ 3# dragonhsu

¬Ý¬Ý¬O§_¦³À°¨ì§A[attach]21286[/attach]
H2ªºÄæ¦ì
{=INDEX($A:$A,SMALL(IF(COUNTIF(¤u§@ªí2!$A$1:$A$8,$A$2:$A$7)>0,ROW($A$2:$A$7),65536),ROW(A1))) & ""}
I2ªºÄæ¦ì
{=INDEX(¤u§@ªí2!$A:$A,SMALL(IF(COUNTIF($A$2:$A$7,¤u§@ªí2!$A$1:$A$8)=0,ROW(¤u§@ªí2!$A$1:$A$8),65536),ROW(A1))) & ""}