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

[µo°Ý] ¨D¸Ñ¦p¦ó§â¤u§@­¶2¸ê®Æ¿z¿ï¨ì¤u§@­¶3

[µo°Ý] ¨D¸Ñ¦p¦ó§â¤u§@­¶2¸ê®Æ¿z¿ï¨ì¤u§@­¶3

¨D¸Ñ

³Â·Ð¦U¦ì¤j¤jÀ°§Ú¸Ñµª¤@¤U¡C

´ú¸Õ«Ü¤[¤@ª½¥¢±Ñ¡C


¨D¸Ñ.rar (10.65 KB)

¦^´_ 1# keovin790916

¥u¯à¥ÎVBA

¨Ò¦p
    Q.zip (17.74 KB)
ss

TOP

¦^´_ 2# sunnyso


    ¨S¿ìªk¥Î¨ç¼Æ¿z¿ï¹L¨Ó?

TOP

¦^´_ 3# keovin790916


¬Ý¤£¤ÓÀ´°ÝÃD¡A¥i¥H»¡©ú¤@¤U§A­n¹F¨ìªº¬O¤°»ò®ÄªG¶Ü¡H

TOP

¦^´_ 4# Bodhidharma


   



¤u§@­¶2ªº¸ê®Æ¿z¿ï¨ì¤u§@­¶3

TOP

¦^´_ 5# keovin790916

¤£¤Ó½T©w§A­nªº®æ¦¡¬Oªø«ç¼Ë
°²³]§A¤é´Á©ñSheet1!L3¡A³æ¦ì©ñSheet1!L4¡A«~¶µ©ñSheet1!L5
Sheet1!M3¤½¦¡
=INDEX(INDIRECT("¨D¸Ñ!"&ADDRESS(MATCH(L3,¨D¸Ñ!A:A,0)+1,1)&":"&ADDRESS(MATCH(L3,¨D¸Ñ!A:A,0)+21,15)),MATCH(L5,INDIRECT("¨D¸Ñ!"&ADDRESS(MATCH(L3,¨D¸Ñ!A:A,0)+1,1)&":"&ADDRESS(MATCH(L3,¨D¸Ñ!A:A,0)+21,1)),0),MATCH(L4,INDIRECT("¨D¸Ñ!"&ADDRESS(MATCH(L3,¨D¸Ñ!A:A,0)+1,1)&":"&ADDRESS(MATCH(L3,¨D¸Ñ!A:A,0)+1,15)),0))
¬O§A­nªº¶Ü¡H


¨D¸Ñ.rar (11.55 KB)

TOP

        ÀR«ä¦Û¦b : ¤H¥Í¤£¤@©w²y²y¬O¦n²y¡A¦ý¬O¦³¾ú½mªº±j¥´ªÌ¡AÀH®É³£¥i¥H´§´Î¡C
ªð¦^¦Cªí ¤W¤@¥DÃD