ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

excel¹ïÀ³¸ê®Æ¤Î¥¼¹ïÀ³¸ê®Æ§e²{

excel¹ïÀ³¸ê®Æ¤Î¥¼¹ïÀ³¸ê®Æ§e²{

½Ð°Ý¦U¦ì°ª¤â

¥i¥H±N§ÚEXCEL¤u§@ªí2±½´yªº½s¸¹¥i¥H¹ïÀ³¤u§@ªí1 AÄæ¦ìªº½s¸¹¶ñ¼g¨ìHÄæ¦ì

µM«á¥¼·j´M¨ìªº½s¸¹¨ì¤u§@ªí1ªºIÄæ¦ì


ÁÂÁ¤j®a

¬¡­¶Ã¯1.zip (7.83 KB)

¤u§@ªí1.jpg (93.24 KB)

¤u§@ªí1.jpg

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

TOP

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

TOP

¦^´_ 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))) & ""}

TOP

        ÀR«ä¦Û¦b : «Ý¤H°h¤@¨B¡A·R¤H¼e¤@¤o¡A´N·|¬¡±o«Ü§Ö¼Ö¡C
ªð¦^¦Cªí ¤W¤@¥DÃD