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

[µo°Ý] ½Ð°Ý¤@¤UVLOOKUP¦h­«¯Á¤Þªº°ÝÃD

[µo°Ý] ½Ð°Ý¤@¤UVLOOKUP¦h­«¯Á¤Þªº°ÝÃD

¦U¦ì°ª¤â¤j­ô±z­Ì¦n
½Ð°Ý¤@¤U
¦³¿ìªkÅýB4¥i¥H¥ÎB2ªº­È¨Ó¯Á¤Þ
¸ê®ÆªíCARDªºµo¥d»È¦æ¶Ü
­n¥i¥H¹³B13³o¼Ë¥i¥H©Ôªº
¦]¬°¥i¯à«È¤á·|¦³«Ü¦h±i«H¥Î¥d
§Ú¬O¥Î¨­¤ÀÃÒ¨Ó·í¯Á¤Þ­È
¥ÎVLOOKUP¥u·|¸õ¥X³Ì«á¤@­Ó»È¦æ
¨S¿ìªk¦h­«¯Á¤Þ
¤£ª¾¹D¦U¦ì°ª¤â¤j­ô¦³¤°»ò¤èªk©O
VBA¤]¬O¥i¥Hªº
ÁÂÁÂÁÂÁÂ
:)

½Æ»s -ªþ¥ó5.rar (13.63 KB)

¦^´_ 1# taliban2008


    ¿é¤J°ÏD1°}¦C¤½¦¡
{=IF(COUNTIF(ªí®æ_W10W13[[#¥þ³¡],[CODE]],¿é¤J°Ï!$B$2)<ROW(A1),"",INDEX(ªí®æ_W10W13[[#¥þ³¡],[CARD_BANK]],SMALL(IF(ªí®æ_W10W13[CODE]=¿é¤J°Ï!$B$2,ROW(ªí®æ_W10W13[CODE]),""),ROW(A1)),))}
¦V¤U½Æ»s¨ì³Ì¦h¥i¯àªºµo¥d»È¦æ¼Æ
«Ø¥ß©w¸q¦WºÙbank¤½¦¡
=OFFSET(¿é¤J°Ï!$D$1,,,LOOKUP(1,1/(¿é¤J°Ï!$D:$D<>""),ROW(¿é¤J°Ï!$D:$D)),)
B4ÅçÃÒ²M³æ¤½¦¡
=bank
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 1# taliban2008


¤£ª¾¥i§_½Ð±z±NÀÉ®×Âà¦s2003ª©¥»ªºxls«¬ºA©O?·PÁ±z!

TOP

¥»©«³Ì«á¥Ñ Hsieh ©ó 2011-7-21 12:11 ½s¿è

¦^´_ 3# onegirl0204


    «Øij¨ì·L³n¤U¸üÂà´«¼W¯q¶°¦w¸Ë
Microsoft Office Word¡BExcel ¤Î PowerPoint Àɮ׮榡¬Û®e©Ê®M¥ó
´N¥i¥H¶}±Ò·sª©¤å¥ó
¤£¹L¦¹¨Òªº»yªk¬O·sª©EXCEL¤¤¤~¥i¨Ï¥Îªº»yªk
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¥»©«³Ì«á¥Ñ 317 ©ó 2011-7-21 20:32 ½s¿è

¦^´_ 4# Hsieh
¤j¤j¦n,
excel¨ì¤F¤µ¤Ñª©¥»¤w¸g¬O2010, ¬Û«H«Ü¦h¤j¤j­Ì, ¥]¬A¥»¤H¦b¤ºÁÙ¬Oªu¥Î03ª©, ¬Ý¤F¦¹¬q¤å, ½×¤Î·sª©¤~¯à¨Ï¥Î¦¹»yªk, ¤£¸T¥O§Ú¦³¤@ºÃ°Ý, °²­Y§Ú²{®É§ó´«¤Fexcel2010, ¨º»ò§Ú­ì¥»©ó03ª©¤¤ªºÀɮײ¾¦Ü·sª©, ·í¤¤¥Î¶}ªº¥¨¶°µ{¦¡´N¬O§_ÁÙ¯à¨Ï¥Î, ´N¬O§_¦³·sª©¤§¤À, ±æ¤j¤j¸Ñ§ÚºÃ°Ý, ÁÂÁÂ!!

TOP

¦^´_ 5# 317

VBA¤è­±ªºÅÜ°Ê·íµM¤]¬O¦s¦bªº¡A¦³¨Ç2003ª©ªºª«¥ó¡A¨ì¤F2007ªO´N³QìI±¼¤F
¹³³oºØ±¡§Î¡A´N¥²¶·­«·s­×§ïµ{¦¡¤w²Å¦X·sª©¥»»yªk¡C
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 6# Hsieh
ÁÂÁª©¥D¤j¤j¦^À³, §Ú¤@ª½¥H¬°·sª©¤À§O¦b©ó¤¶­±¤Î¥\¯à¤W, ­ì¤W¦b¥¨¶°ªºª«¥ó¤¤¤]¦³ÅÜ°Ê, ¦AÁÂÁ¦^À³.
¯¬Ä@§Ö¼Ö...

TOP

ÁÂÁÂHsieh¤j¤jªºÀ°¦£
ÁÙ¦³¦U¦ì¤j­ô¤j©jªº¼ö¤ß¦^´_
¤p§Ì°¨¤W¥h¸Õ¬Ý¬Ý
«D±`·PÁ¤j®a
ÁÂÁ±z­Ì

TOP

¦^´_  Hsieh
ÁÂÁª©¥D¤j¤j¦^À³, §Ú¤@ª½¥H¬°·sª©¤À§O¦b©ó¤¶­±¤Î¥\¯à¤W, ­ì¤W¦b¥¨¶°ªºª«¥ó¤¤¤]¦³ÅÜ°Ê, ¦A ...
317 µoªí©ó 2011-7-22 07:20



°U±zªººÖ¡ãÅý§Ú¤]¼Wªø¤F¦³Ãö·sª©ªº®t²§ª¾ÃÑ¡I¤£ª¾±z»{¬°¦³¥²­nÂà´«¦¨·sª©ªº¶Ü¡H¦]¬°§Ú­Ó¤H¤´¾¥¦u¦¨³W¡ã¨Ï¥Îª©ªº¸û¶¶¤â¡I

TOP

¦^´_ 9# onegirl0204
¨Ï¥Î­þ­Óª©¥»?­Ó¤H»{¬°°÷¥Î´N¦n
·sª©Áö¦³³\¦h·s¥\¯à¡A¦ý¬O­Y±zªº¤u§@¤W¥Î¤£¨ì¡A´N¨S¥²­nªá¿ú§ó·s
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

        ÀR«ä¦Û¦b : ¦h°µ¦h±o¡C¤Ö°µ¦h¥¢¡C
ªð¦^¦Cªí ¤W¤@¥DÃD