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

[µo°Ý] ½Ð±ÐÃö©óºI¨úÀx¦s®æ¤¤ªº°ß¤@­È

¦^´_ 10# oobird

[oobird]ª©¥D,¯u¬OÃø¬°±z¤F,¸g´ú¸Õ¤w¥¿½T,ÁÂÁÂ
°¶Ôйq¤l®Ñ,Åwªï§K¶O¤U¸ü°Ñ¦Ò
http://www.twbts.com/ebook/?subject=office
http://www.twbts.com/ebook/?subject=soft
°¶ÔÐÂîѮw---https://www.facebook.com/groups/669579416484096/
¦³¤@®a¬a¥J©±---https://www.facebook.com/sadodona

TOP

¦^´_ 10# oobird

¬Q¤Ñ¦A¨Ï¥Î®É¤Sµo²{·|¦³º|¸ê®Æ
«á¨Ó±NAÄæ±Æ§Ç«á¦A°õ¦æ´N¥¿±`¤F
¦b¦¹¦^³ø¤@¤U
ÁÂÁÂ!
°¶Ôйq¤l®Ñ,Åwªï§K¶O¤U¸ü°Ñ¦Ò
http://www.twbts.com/ebook/?subject=office
http://www.twbts.com/ebook/?subject=soft
°¶ÔÐÂîѮw---https://www.facebook.com/groups/669579416484096/
¦³¤@®a¬a¥J©±---https://www.facebook.com/sadodona

TOP

­Ë¥i¸ÕµÛ§â¸ê®Æ¾ã²z«á¥Î¼Ï¯Ã¤ÀªR
¸ê®Æªí.rar (11.27 KB)
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

­Ë¥i¸ÕµÛ§â¸ê®Æ¾ã²z«á¥Î¼Ï¯Ã¤ÀªR
Hsieh µoªí©ó 2010-10-13 10:45



   ¤£¿ù¡A ¦nÂI¤l¡C¤£¹L¾ã²z¸ê®Æ¥i¯à¤Ö¤£±oÁÙ¬O­nvba§a¡C

TOP

¦^´_ 14# oobird


    ¨þ¨þ!
§Ú¨S¥Î¥ô¦ó¤@¥yvba£z£°
¥i§Q¥Î©w¸q¦WºÙ¨Ó¿ï¨ú²¾°Ê
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 13# Hsieh

ÁÂÁÂ[Hsieh]ª©¥D´£¨Ñ¥t¤@ºØ¸Ñªk

§Ú¨S¥Î¥ô¦ó¤@¥yvba£z£°
¥i§Q¥Î©w¸q¦WºÙ¨Ó¿ï¨ú²¾°Ê
Hsieh µoªí©ó 2010-10-13 14:40


§Ú¬Ý¨ì©w¸q¦WºÙX=OFFSET(ÃöÁä¦r¤Uªº¦~¥N!$A5,,,,LOOKUP(9.9E+307,ÃöÁä¦r¤Uªº¦~¥N!5:5,COLUMN(ÃöÁä¦r¤Uªº¦~¥N!5:5)))
¤£©úÁA¬°¦ó³o»ò³]?
¥t¥~,[ÃöÁä¦r¤Uªº¦~¥N]¤u§@ªí¤¤ªºA¤ÎBÄæ¬O«ç»ò¾ã²z¥X¨Óªº?
¥H¤WÁÙ½Ð[Hsieh]ª©¥D¸Ñ»¡¤@¤U
ÁÂÁÂ!
°¶Ôйq¤l®Ñ,Åwªï§K¶O¤U¸ü°Ñ¦Ò
http://www.twbts.com/ebook/?subject=office
http://www.twbts.com/ebook/?subject=soft
°¶ÔÐÂîѮw---https://www.facebook.com/groups/669579416484096/
¦³¤@®a¬a¥J©±---https://www.facebook.com/sadodona

TOP

¥»©«³Ì«á¥Ñ Hsieh ©ó 2010-10-13 19:29 ½s¿è

¦^´_ 16# °¶ÔÐ
·íµM­º¥ý¥²¶·¥ý±NBÄæ¸ê®Æ­åªR
¦]¬°¥²¶·¨Cµ§¹ïÀ³ÃöÁä¦r©Ò¥H¨C­Ó¡B¦ì¸m­n¦h¥X¤@ÄæªÅ¥ÕÄæ¦ì
©Ò¥H¥ý¥Î¨ú¥N¥\¯à±N¡B¨ú¥N¬°¡B¡B
¦A¥H¡B°µ¤À¹j²Å¸¹­åªR
x¦WºÙ¬O¬°¤F­n¿ï¨ú¾ã¦C¦³¸ê®Æªº½d³ò
©w¸q¦nx¦WºÙ«á
ÂI¿ïA2µM«á¦b¦WºÙ¤è¶ô¿é¤Jx«öENTER
«öF5¿ï¯S®íÀx¦s®æ"ªÅ®æ"
¿é¤J=$A2«öCTRL+ENTER¿é¤J¤½¦¡«K¯à¶ñº¡
¨CÄæªÅ®æ¥H²Ä2¦CÀx¦s®æÂùÀ»¥k¤U±±ÂI¦V¤U¶ñº¡
±µ¤U¨Ó¥ÑCÄæ¶}©l2Äæ¤@°_²¾¦ÜAÄæ¸ê®Æ©³³¡

·íµM¥H¤W¾Þ§@¨Ã«D°ß¤@¤èªk¡A©Î³\±z¦³§ó²z·Qªº¤èªk
§Ú³o¼Ëªº¤èªk³Ì¥D­n¬O¦b»¡©ú§Q¥Î©w¸q¦WºÙ¿ï¨ú¸ê®Æªº¤èªk
¦³§ó¦nªº¤èªkÅwªï´£¥X¨ÓÅý¤j®a½m²ß
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_  °¶ÔÐ
¿é¤J=$A2«öCTRL+ENTER¿é¤J¤½¦¡«K¯à¶ñº¡
¨CÄæªÅ®æ¥H²Ä2¦CÀx¦s®æÂùÀ»¥k¤U±±ÂI¦V¤U¶ñº¡
±µ¤U¨Ó¥ÑCÄæ¶}©l2Äæ¤@°_²¾¦ÜAÄæ¸ê®Æ©³³¡
Hsieh µoªí©ó 2010-10-13 18:49


§Ú¸Õ¤F¤@¤U,¬O¤£¬O¿é¤J=$A1«öCTRL+ENTER
¦]¬°­Y¬O=$A2,¦n¹³¸ê®Æ·|©¹¤W¶]¤@¦C

¥t¥~,"¨CÄæªÅ®æ¥H²Ä2¦CÀx¦s®æÂùÀ»¥k¤U±±ÂI¦V¤U¶ñº¡",¤£À´
¤£¬O³£³Q¤½¦¡¶ñº¡¤F,«ç»òÁÙ¦³ªÅ®æ?

¦A³Â·Ð[Hsieh]ª©¥D¸ÑºÃ,ÁÂÁ¡I

991013.zip (8.63 KB)

°¶Ôйq¤l®Ñ,Åwªï§K¶O¤U¸ü°Ñ¦Ò
http://www.twbts.com/ebook/?subject=office
http://www.twbts.com/ebook/?subject=soft
°¶ÔÐÂîѮw---https://www.facebook.com/groups/669579416484096/
¦³¤@®a¬a¥J©±---https://www.facebook.com/sadodona

TOP

·Pı§¹¥þ¤£¥Î¤½¦¡¤]ªá¤£¤F¦h¤Ö®É¶¡¡C
¿ý±o¤Ó¤j¤F¡A¼vÅTÂsÄý¡A§Ú§â¸ê®Æ­åªRªº³¡¤À²¤¹L¡A­«¿ý¤@­Ó¡C

x.gif (693.45 KB)

x.gif

TOP

¥»©«³Ì«á¥Ñ Hsieh ©ó 2010-10-14 00:01 ½s¿è

¦^´_ 18# °¶ÔÐ
§Úªº°µªk¤Ï¦Ó½ÆÂø¤F
oobirdªº°µªk½T¹ê¬O²³æ¦h¤F
¦b¦¹¯S§O¤@´£¡A2007ª©¦³¤@¸ê®Æ/²¾°£­«½Æ¥\¯à
·íoobirdª©¤j§¹¦¨Âà¸m®É¡A¥Î¦¹¥\¯à´N¥i±N­«ÂЪº¦~¥÷²¾°£
¦b¦¹¦^Âа¶ÔÐ
§ÚªºX©w¸q¦b©w¸q®É­n¥H¬Û¹ï°Ñ·Óªº¦P¦C¨Ó¤U©w¸q
´N¬O»¡¦b©w¸qªº®É­Ô­Y§@¥ÎÀx¦s®æ¦b²Ä2¦C®É
°Ñ·Ó¨ìªº¤½¦¡¬O=OFFSET(ÃöÁä¦r¤Uªº¦~¥N!$A2,,,,LOOKUP(9.9E+307,ÃöÁä¦r¤Uªº¦~¥N!2:2,COLUMN(ÃöÁä¦r¤Uªº¦~¥N!2:2)))
§A¬Ý¨ì=OFFSET(ÃöÁä¦r¤Uªº¦~¥N!$A5,,,,LOOKUP(9.9E+307,ÃöÁä¦r¤Uªº¦~¥N!5:5,COLUMN(ÃöÁä¦r¤Uªº¦~¥N!5:5)))
¬O¦]¬°§A§@¥ÎÀx¦s®æ°±¦b²Ä5¦C©Ò¥H¬Ý¨ìªº¤½¦¡¬O¥H²Ä5¦C¬°¬Û¹ï°Ñ·Ó
·í§A¦bA2¤]¬O¿é¤J¦¨=OFFSET(ÃöÁä¦r¤Uªº¦~¥N!$A5,,,,LOOKUP(9.9E+307,ÃöÁä¦r¤Uªº¦~¥N!5:5,COLUMN(ÃöÁä¦r¤Uªº¦~¥N!5:5)))
©Ò¥H·|¸õ¨ì²Ä5¦C°µ¿ï¨ú

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

TOP

        ÀR«ä¦Û¦b : ¡i¦æµ½­n¤Î®É¡j¦æµ½­n¤Î®É¡A¥\¼w­n«ùÄò¡C¦p¿N¶}¤ô¤@¯ë¡A¥¼¿N¶}¤§«e¤d¸U¤£­n°±º¶¤õ­Ô¡A§_«h­«¨Ó´N¤Ó¶O¨Æ¤F¡C
ªð¦^¦Cªí ¤W¤@¥DÃD