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

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

¦^´_ 4# Hsieh


½Ð°Ý¡G¤U¸ü¬Û®eªº³nÅé«á¡A¥u¯à¶}±Ò¤Î¾\Äý·sª©ÀɮצӤ£¯à¦sÀɬO¶Ü¡HÁÂÁ½ç±Ð¡I

TOP

¦^´_ 11# onegirl0204


   ¦w¸Ë 2007 office system ¬Û®e©Ê®M¥ó ·|¥H§A²{¦bªº®æ¦¡Åª¨ú2007 office»s§@ªº¤å¥ó
·íµM¤]¥i¥HÀx¦s¡A¥H§A²{¦bªº®æ¦¡Àx¦s¡I

TOP

¦^´_ 12# oobird


·PÁ±zªºµªÂСI

¦ý¦]­Ó¤H¸ê½è·M¬N¡A·Q½Ð±z¦A½T»{¤@¥ó¨Æ¡ã§Ú­Y¦w¸Ë¬Û®e³nÅéŪ¨ú·sª©excelÀÉ¡AÀx¦sªºÀɮ׫¬ºA¤´¬°.xls¶Ü¡H¦]¬°§Ú·|¥Îexcel³]­p¤@¨Ç¾Ç®Õ±`¥Îªº¸ê®Æ³B²z¡A­Y¬O²¾Âà¦Ü¾Ç®Õ¤£¯à¥Î2003ªºÂÂÀɮ׫¬ºA.xls¶}±Ò¡A¨º»ò¬Û®e³nÅé¹ï§Ú´N¨S¤°»ò·N¸q¤F¡I­ì¦]¤£¥~¬O¾Ç®Õ®Ú¥»¤£¥i¯àÅý§ÚÀH«K¤U¸ü¬Û®e³nÅé¡A®a¸Ì³]­pªºÀɮפ£¯à¦b®Õ¨Ï¥Î¡A¨º§Ú¹ç¥i©ñ±ó¾Ç²ß·sª©³nÅ骺¾÷·|Åo¡I

½Ð«e½ú¦A¦¸½ç±Ð¡AÁÂÁ¡I

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

¦^´_ 10# Hsieh


Hsieh¤j¤j±z¦n
±zªº±Ð¾Ç³o´X­Ó³¡¥÷
¤p§Ì¤£ª¾¹D¬O¤£¬O¤£·|¥Î
¥X¨Óµ²ªG¬O¿ùªº:(

«Ø¥ß©w¸q¦WºÙbank¤½¦¡
=OFFSET(¿é¤J°Ï!$D$1,,,LOOKUP(1,1/(¿é¤J°Ï!$D:$D<>""),ROW(¿é¤J°Ï!$D:$D)),)
B4ÅçÃÒ²M³æ¤½¦¡
=bank

¥i¥H½Ð±z¦A«ü¾É¤@¤U¶Ü
¯u¤£¦n·N«ä
«D±`·PÁ±zÁÂÁ±z

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

TOP

¦^´_ 15# taliban2008


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

TOP

¦^´_ 16# Hsieh


­ì¨Ó¬O³o¼Ë
ÁÂÁ±z°Ú
«D±`·PÁ±zÁÂÁ±z

TOP

¬O°Ú¬O°Ú
¤£¤@©w­n¤É¯Åªº©Ô
¥ú¬OºN¯Á¥\¯à¦b¨º
´N­nªá¤£¤Ö®É¶¡©O
jeason

TOP

03 ¦³­þ¨Ç¥\¯à³Q³B²z±¼©O¡H
­É¿ú¤£ÁÙ¡A¤~¬O¤ý¹D

TOP

¤S,¾Ç¨ì¤F¤@©Û~¯u¬O¤Ó¦n¤F~¾Çªº¶V¦h¥Nªí¶V¥i¥H§Q¥Îexcel°µ§ó¦hªº¨Æ

TOP

        ÀR«ä¦Û¦b : ºÉ¦h¤Ö¥»¥÷¡A´N±o¦h¤Ö¥»¨Æ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD