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

¦p¦ó³]¨ç¼Æ¤½¦¡³sµ²¥[Á`¤G­Ó¥H¤W¼ÐÅÒ­¶¸Ìªº¸ê®Æ??

¦^´_ 10# jumky
­Y¨Ï¥Î¤½¦@©w¸q¡A³o¼Ë¨C¦¸¤Á´«¦X­p¤u§@ªí³£¥²¶·«öF9­«ºâ

e.rar (5.65 KB)
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 11# Hsieh


    ½Ð°Ý¤j¤j¡G¥¦¼ÐÅÒ­¶¦WºÙ¬°¦X­p-98´N·|¥X²{¿ù»~..?½Ð°Ý¤@¤U¨º­Ó"¦~"©w¸q¬°¦ó¨º¼Ë³]..?¦pªþ¥ó H.rar (6.6 KB)

TOP

¦^´_ 12# jumky

½Ð¥ý§â©w¸qÆ[©ÀÂç²M

   http://forum.twbts.com/thread-1405-1-1.html
¥ßÅé°Ñ·Óªº¨Ï¥Î¥²¶·ª`·N´XÂI
1.µLªk¨Ï¥Î°}¦C¤½¦¡
2.¥u¯à¾A¥Î¥H¤U´X­Ó¨ç¼Æ
SUM - ·s¼W¼Æ¦r
AVERAGE - ­pºâ¼Æ¦r¥­§¡ (ºâ³N¤èªk)
AVERAGEA - ­pºâ¼Æ¦r¥­§¡ (ºâ³N¤èªk)¡F¥]§t¤å¦r»PÅÞ¿è­È
COUNT - ­pºâ¥]§t¼Æ¦rªºÀx¦s®æ
COUNTA - ­pºâ¤£¬OªÅ¥ÕªºÀx¦s®æ
MAX - §ä¥X­È¶°¤¤ªº³Ì¤j­È
MAXA - §ä¥X­È¶°¤¤ªº³Ì¤j­È¡F¥]§t¤å¦r»PÅÞ¿è­È
MIN - §ä¥X­È¶°¤¤ªº³Ì¤p­È
MINA - §ä¥X­È¶°¤¤ªº³Ì¤p­È¡F¥]§t¤å¦r»PÅÞ¿è­È
PRODUCT - ­¼¤W¼Æ¦r
STDEV - ®Ú¾Ú¼Ë¥»­pºâ¼Ð·Ç®t
STDEVA - ®Ú¾Ú¼Ë¥»­pºâ¼Ð·Ç®t¡F¥]§t¤å¦r»PÅÞ¿è­È
STDEVP - ­pºâ¾ã­Ó¥À¼Æªº¼Ð·Ç®t
STDEVPA - ­pºâ¾ã­Ó¥ÀÅ骺¼Ð·Ç®t¡F¥]§t¤å¦r»PÅÞ¿è­È
VAR - ®Ú¾Ú¼Ë¥»¦ô­pÅܼÆ
VARA - ®Ú¾Ú¼Ë¥»¦ô­pÅܼơF¥]§t¤å¦r»PÅÞ¿è­È
VARP - ­pºâ¾ã­Ó¥ÀÅ骺ÅܼÆ
VARPA - ­pºâ¾ã­Ó¥À¼ÆªºÅܼơA¥]§t¤å¦r»PÅÞ¿è­È

3.­pºâ½d³ò¦b¨C­Ó¤u§@ªíªº¦ì¸m­n¬Û¦P
¦Ü©ó¦WºÙ¡u¦~¡vªº©w¸q
=--SUBSTITUTE(MID(CELL("filename"),FIND("]",CELL("filename"))+1,256),"¦X­p-","")
¬O§Q¥ÎCELL¨ç¼Æ¨ú±oÀɮתº§¹¾ã¥Ø¿ý¦r¦ê«á¡A§ä¨ì "]" ¤¤¬A¸¹¦ì¸m¡A¥H«áªº¦r¦ê´N¬O¤u§@ªí¦WºÙ
±N«D¼Æ¦r³¡¤À¦r¦ê¨ú¥N«á´N·|¶Ç¦^¦~«×
§ï¦¨= --SUBSTITUTE(SUBSTITUTE(MID(CELL("filename"),FIND("]",CELL("filename"))+1,256),"¦X­p-",""),"¦~","")
H.zip (7.9 KB)
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 13# Hsieh


    ½Ð°Ý¤j¤j¡G¨º¨C­Ó¼ÐÅÒ­¶ªº¦WºÙ³£¤£¦P,¬O§_´NµLªk¥Î¦¹"¦~"ªº©w¸q,¦pªþ¥ó I.rar (6.67 KB) ...¥B¦³®É«öF9·|­«·s­pºâ.¦³®É¤£·|?

TOP

¦^´_ 14# jumky
Á`¤§¡A§A¥²¶·±N¦WºÙ¡u¦~¡vªº¤½¦¡§ï¹D¯à°÷¥u³Ñ¤U¦~«×ªº¼Æ­È
§_«h§A´N¥²¶·¦b¨C­Ó¤u§@ªí¤¤ªº©T©w¦ì¸m¿é¤J¦~«×
µM«á¡u¦~¡v¦WºÙ¥h°Ñ·Ó¨ì¸Ó¦ì¸m
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 15# Hsieh


    ½Ð±Ð¤j¤j¡G¦]¬°¤U¤è¼ÐÅÒ­¶¦WºÙ¤£¦P,¤À§O¬°
    98¦~(³ÍÂ×)-¶i³f¨ì98.12.31        99¦~(³ÍÂ×)-¶i³f¨ì99.12.31     100¦~(³ÍÂ×)   ¦pªþ¥ó I.rar (6.69 KB)
   
      ¦X­p-98¦~«×        ¦X­p-99¦~«×     ¦X­p-100¦~«×
©Ò¥H§Ú±N"¦~"ªº©w¸q¦WºÙ§ï¬°= --SUBSTITUTE(SUBSTITUTE(MID(CELL("filename"),FIND("]",CELL("filename"))+1,256),"¦X­p-","¦~«×",""),"¦~(³ÍÂ×)-","")
¥i¥¦·|¥X²{¤Þ¼Æ¿ù»~....½Ð¤j¤j«üÂI¸Ó¦p¦ó§ï...??

TOP

¦^´_ 16# jumky


    98¦~(³ÍÂ×)-¶i³f¨ì98.12.31        
§Aı±o³o­Ó¦r¦ê¥Î¬Æ»ò¤èªk¥i¥H¥u±o¨ì³Ì«e­±ªº¼Æ¦r98©O?
¤F¸Ñ³o­Ó¤½¦¡¬Ý¬Ý
=--LEFT("98¦~(³ÍÂ×)-¶i³f¨ì98.12.31",FIND("¦~","98¦~(³ÍÂ×)-¶i³f¨ì98.12.31")-1)
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 17# Hsieh


    ¶â...ÁÂÁÂHsieh¤j¤j..^^

TOP

        ÀR«ä¦Û¦b : ¤H­nª¾ºÖ¡B±¤ºÖ¡B¦A³yºÖ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD