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

¸ê®Æ¿z¿ïÀ³¥Î

¸ê®Æ¿z¿ïÀ³¥Î

½Ð°Ý°ª¤â¥H¤U¬°¤p§Ìªº»Ý¨D¬°¡G¨C¦¸TXTÀɸê®Æ¶i¨Ó«á·|¤À§O±N¨âµ§²£«~ªº001²£«~¤º²Ä2­ÓÀË¥X¡A¥H¤Î002²£«~¤º®e²Ä4­ÓÀË¥X¡AÅã¥Ü¦b¨ä¾lÀx¦s®æ¤º
¦p¤U¹Ï©Ò¥Ü¡A½Ð°ª¤â«ü¾É¡AÁÂÁÂ


20151118 TEST.rar (8.4 KB)

http://blog.xuite.net/hcm19522/twblog/357885832

TOP

¦^´_ 2# hcm19522


    H¤j¤j¡A¦pªG§Úªº»Ý¨D¬O «á¤T½X001¡B002 ³£Åã¥Ü²Ä2­ÓÄæ¦ì¤£¥Î¥h§PÂ_¡A·|¤£·|¤ñ¸û¦n¼g...¡H
    ¦]¬°§Ú¬Ý¤£À´³o­Ó½d¨Ò....U2:U14=OFFSET(A$1,MAX(IF((MOD(COLUMN(A$2:G$14),6)=1)*(A$2:G$14=S2),ROW(A$2:G$14)-1)),IF(--RIGHT(S2)=1,2,10))
    §Úµy·L®M¥Î«áÁÙ¬OµLªkÅã¥Ü....>0<"
    ½Ð¤j¤jÀ°¦£~QQ

TOP

¢Ñ¢·¡G=IF(B8="","",VLOOKUP(B8,B$3:G$4,C$7+1,))
¢Ó¢·¡G=IF(D8="","",VLOOKUP(D8,H$3:M$4,E$7+1,))

TOP

¦^´_ 4# ­ã´£³¡ªL


    ·PÁ­ã¤j¦^´_ ^^

TOP

¦^´_ 4# ­ã´£³¡ªL

­ã¤j ½Ð°Ý¢Ñ¢·¡G=IF(B8="","",VLOOKUP(B8,B$3:G$4,C$7+1,)) ¡A
B8Àx¦s®æ  001 «e­±ªº¤å¦r¤£¤@©w ³o¼Ë´NµLªk¥ÎVlookup¤F
¦³¤°»ò¿ìªk¶Ü ¡H >0<

TOP

¦^´_ 6# Jason80Lo


½Ð´£¨Ñ§ó¦hªº½d¨Ò, ¤~¯à§PÂ_¨Ï¥Î¤èªk!!

TOP

        ÀR«ä¦Û¦b : ¤@¥y·Å·xªº¸Ü¡A´N¹³©¹§O¤H¨­¤WÅx­»¤ô¡A¦Û¤v·|ªg¨ì¨â¤Tºw¡C
ªð¦^¦Cªí ¤W¤@¥DÃD