[µo°Ý] ½Ð±Ð¤@¤U¤U©Ô¿ï³æ¥h¿ï¨ú¸s²Õªº°ÝÃD

kevin76525

¤£¦n·N«ä¡A¤p§Ì¦b·s¤½¥q²Ä¤@¦¸¥²¶·¨Ï¥Î¨ì³o»ò²`¼hªºEXCEL§Þ¥©
©Ò¥H¦³º¡¦hªF¦è¤£À´~³oÃä°Ý¤@¤U¦U¦ì¤j¤j~
¤p§Ì¦b±M®×¤W¦WºÙ¥s"¾ú¥v¸ê®Æ¬d¸ß¨t²Î"¬G¦W...¥L¸ê®Æº¡Ãe¤jªº
¤p§Ì§Q¥Î¤F¤@­Ó¤ëªº¸ê®Æ¾ã²z»P³W¹º¤j¦Ü¤W¤w¸g§¹¦¨50%¥ª¥kªº¥\¯à...
¦ý²{¦b¥d¦b¤@­Ó³Ì­«­nªº¦a¤è...
¤p§Ì«e­±ªº¤U©Ô¬O¨Ï¥Î ¿¤¥«¦a°Ïªº¤è¦¡ ¥Î¨ç¦¡§@¥X ¤U©Ô©IÀ³¹ï·Óªº
¦ý«á­±ªº¦]¬°¬O¸ê®ÆÃe¤jÃö«YÅܦ¨¨Ï¥Î¸s²Õ¤è¦¡¾ã²z...©Ò¥H...³oÃä´N¥d¦í¤F>"<
¦Ó¥B«áºÝªº¤@¨Ç¸ê®Æ¤]¥²¶·¹ïÀ³Åã¥Ü¥X¤U©Ô¿ï¨ú«áªº¸ê®Æ...
¤p§Ìªº°ÝÃD¤]¼g¦bÀɮ׸̭±....§Æ±æ¦³²M·¡ªºªí¹F¥X¨Ó>"<
§Æ±æ¦U¦ì¤j¤j¯àÀ°¦£¤p§Ì~·P®¦....

javascript:;javascript:;

Hsieh

¦^´_ 1# kevin76525
¿ï¨ú¥D­¶²Ä4¦C¥ô¤@Àx¦s®æ
·s¼W¥H¤U¦U¦WºÙ
Rng=INDIRECT(SUBSTITUTE(SUBSTITUTE(¥D­¶!$B4,"¤j¼Ó",""),"¬hÀç","")&LEFT(¥D­¶!$C4,2)&"!A:G")
k=MATCH(TRUE,OFFSET(INDEX(Rng,MATCH(¥D­¶!$D4,INDEX(Rng,,1),0)+1,1),,,1000,)="",0)  
list=OFFSET(INDEX(Rng,MATCH(¥D­¶!$D4,INDEX(Rng,,1),0)+1,1),,,k-1,)
x=INDEX(list,MATCH(¥D­¶!$E4,list,0),1)
¥D­¶EÄæ¸ê®ÆÅçÃÒ²M³æ¤½¦¡
=list
F4¤½¦¡
=IF(ISERROR(x),"",OFFSET(x,,COLUMN(A$1)))
¦V¥k¦V¤U½Æ»s
¤uµ{»P³]³Æ¾ú¥v¬d¸ß¨t²Î.zip (431.88 KB)

¤U¸ü¦¸¼Æ: 8

2014-7-28 10:39

¤U¸ü (132.84 KB)

2014-7-28 10:42

kevin76525

¦^´_ 2# Hsieh


·PÁª©¤jÀ°¦£¡A¤p§Ì¥Ø«e¤£¯à¤U¸üÀɮסA
ª½±µ·Óª©¤j«ü¥Ü¦A©w¸q·s¦WºÙ¤À§O¬°Rng¡Bk¡Bx©Mlist¥|¶µ
³oÅܦA©w¸q¤W¬O¿ï¾Ü²Ä¥|¦C¥ô¦óÀx¦s®æ¤W©w¸q¡A³o¼Ë¹ï§a@@¡H
³Ì«áEÄæ´N²M³æÅçÃÒlist¡C©Ò¥H¤§«e¤p§Ì«e­±ªº«Ø®×¡BÃþ§O¡B¶µ¥Ø²M³æÅçÃÒ¬O¤£¥Î§ó§ï¹ï§a⋯
©_©Ç⋯«ç»ò¤U©Ô¼Ð¥Ü¶]¥X¨Ó¤F¡A¦ý·|µLªk°µ¿ï¨ú¤º®e©O⋯
¦AEÄæÅçÃÒ¤]¥X²{¡u¨Ó·½ ªº­È±N·|¾É­P¿ù»~¡C±z­nÄ~Äò¶Ü¡H¡v³o¼Ë⋯
¬O¤p§Ì­þ­ôÀôµ²¦³¿ù»~¶Ü⋯¤£¦n·N«ä¦A½Ð±Ðª©¤j±z¤F...·PÁÂ

kevin76525

¦^´_ 2# Hsieh


    ·PÁª©¥D~¦b¤½¥qªº98ªGµM©Ç©Çªº....
¦^®a¥Î13´N¦¨¥\¤F^^~
·PÁÂ~