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

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

¦^´_ 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

¥»©«³Ì«á¥Ñ 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

¦^´_ 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

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

TOP

¬Û®e®M¥ó¶}±Òªº·sª©ÀɮסA½Ð¥t¦s·sÀÉ¡A¦¨¬°xlsÀÉ®×
¦sÀɮɷ|¥X²{¬Û®e©Êĵ§i¡A§A´Nª¾¹D­þ¨Ç¥\¯à¥i¯à¨ü¼vÅT
µM«á¦A¨Ì·Ó§Aªº»Ý¨D¥h§ó§ï¡A¦ÛµM´N¯à²Å¦X2003ª©ªºxls
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 15# taliban2008


   
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

        ÀR«ä¦Û¦b : ¥Í®ð¡A´N¬O®³§O¤Hªº¹L¿ù¨ÓÃg»@¦Û¤v¡C
ªð¦^¦Cªí ¤W¤@¥DÃD