¦p¦ó³]¨ç¼Æ¤½¦¡³sµ²¥[Á`¤GÓ¥H¤W¼ÐÅÒ¶¸Ìªº¸ê®Æ??
- ©«¤l
- 100
- ¥DÃD
- 27
- ºëµØ
- 0
- ¿n¤À
- 197
- ÂI¦W
- 0
- §@·~¨t²Î
- windows 7
- ³nÅ骩¥»
- office 2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¤k
- ¨Ó¦Û
- ¥xÆW
- µù¥U®É¶¡
- 2010-5-1
- ³Ì«áµn¿ý
- 2023-6-1
|
¦^´_ 11# Hsieh
½Ð°Ý¤j¤j¡G¥¦¼ÐÅÒ¶¦WºÙ¬°¦Xp-98´N·|¥X²{¿ù»~..?½Ð°Ý¤@¤U¨ºÓ"¦~"©w¸q¬°¦ó¨º¼Ë³]..?¦pªþ¥ó
H.rar (6.6 KB)
|
|
|
|
|
|
|
- ©«¤l
- 4901
- ¥DÃD
- 44
- ºëµØ
- 24
- ¿n¤À
- 4916
- ÂI¦W
- 247
- §@·~¨t²Î
- Windows 7
- ³nÅ骩¥»
- Office 20xx
- ¾\ŪÅv
- 150
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¥_
- µù¥U®É¶¡
- 2010-4-30
- ³Ì«áµn¿ý
- 2024-11-14
|
¦^´_ 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§@ªíªº¦ì¸mn¬Û¦P
¦Ü©ó¦WºÙ¡u¦~¡vªº©w¸q
=--SUBSTITUTE(MID(CELL("filename"),FIND("]",CELL("filename"))+1,256),"¦Xp-","")
¬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),"¦Xp-",""),"¦~","")
H.zip (7.9 KB)
|
|
¾Ç®üµL²P_¤£®¢¤U°Ý
|
|
|
|
|
- ©«¤l
- 100
- ¥DÃD
- 27
- ºëµØ
- 0
- ¿n¤À
- 197
- ÂI¦W
- 0
- §@·~¨t²Î
- windows 7
- ³nÅ骩¥»
- office 2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¤k
- ¨Ó¦Û
- ¥xÆW
- µù¥U®É¶¡
- 2010-5-1
- ³Ì«áµn¿ý
- 2023-6-1
|
¦^´_ 13# Hsieh
½Ð°Ý¤j¤j¡G¨º¨CÓ¼ÐÅÒ¶ªº¦WºÙ³£¤£¦P,¬O§_´NµLªk¥Î¦¹"¦~"ªº©w¸q,¦pªþ¥ó
I.rar (6.67 KB)
...¥B¦³®É«öF9·|«·spºâ.¦³®É¤£·|? |
|
|
|
|
|
|
- ©«¤l
- 100
- ¥DÃD
- 27
- ºëµØ
- 0
- ¿n¤À
- 197
- ÂI¦W
- 0
- §@·~¨t²Î
- windows 7
- ³nÅ骩¥»
- office 2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¤k
- ¨Ó¦Û
- ¥xÆW
- µù¥U®É¶¡
- 2010-5-1
- ³Ì«áµn¿ý
- 2023-6-1
|
¦^´_ 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)
¦Xp-98¦~«× ¦Xp-99¦~«× ¦Xp-100¦~«×
©Ò¥H§Ú±N"¦~"ªº©w¸q¦WºÙ§ï¬°= --SUBSTITUTE(SUBSTITUTE(MID(CELL("filename"),FIND("]",CELL("filename"))+1,256),"¦Xp-","¦~«×",""),"¦~(³ÍÂ×)-","")
¥i¥¦·|¥X²{¤Þ¼Æ¿ù»~....½Ð¤j¤j«üÂI¸Ó¦p¦ó§ï...?? |
|
|
|
|
|
|
- ©«¤l
- 100
- ¥DÃD
- 27
- ºëµØ
- 0
- ¿n¤À
- 197
- ÂI¦W
- 0
- §@·~¨t²Î
- windows 7
- ³nÅ骩¥»
- office 2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¤k
- ¨Ó¦Û
- ¥xÆW
- µù¥U®É¶¡
- 2010-5-1
- ³Ì«áµn¿ý
- 2023-6-1
|
¦^´_ 17# Hsieh
¶â...ÁÂÁÂHsieh¤j¤j..^^ |
|
|
|
|
|
|