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

½Ð°Ý¤½¦¡¦p¦ó¼g¡H

½Ð°Ý¤½¦¡¦p¦ó¼g¡H

½Ð°Ñ¦Òªþ¥ó¡Asheet1 ¬°¨Ó·½¸ê®Æ¡A¥BÀɸ¹¤¤¶¡½s¸¹¬°«D³sÄò¡Asheet2 ¬O©Ò­nªºµ²ªG¡A½Ð°Ý¤½¦¡¸Ó¦p¦ó¼g©O¡HÁÂÁ¡I

Book2.rar (7.12 KB)

¦^´_ 1# aer

Sheet2!A1°}¦C¤½¦¡
=INDIRECT("Sheet1!A"&SMALL(IF(LEFT(Sheet1!$A$1:$A$89,4)="ÀÉ¡@¸¹¡G",ROW($1:$89),""),ROW(A1)))
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

ÁÂÁ¶W¯Åª©¥D¡A°ÝÃD¤w¸Ñ¨M¡C

TOP

        ÀR«ä¦Û¦b : ¤H¥Í¨S¦³©Ò¦³Åv¡A¥u¦³¥Í©Rªº¨Ï¥ÎÅv¡C
ªð¦^¦Cªí ¤W¤@¥DÃD