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

[µo°Ý] Åã¥Ü¥X¦³­ÈªºÀx¦s®æ

[µo°Ý] Åã¥Ü¥X¦³­ÈªºÀx¦s®æ

¤j®a¦n¡G

·Q½Ð°Ý°²¦p¥H¤Uªí

¢@¡@¢é¡@¢ê
¢°¡@¢°¡@¢°
¢±¡@¢°¡@¢°
¢²¡@¢°¡@¢°
¢³¡@¢°¡@¢°
¢´¡@¢°¡@¢°
¢µ
¡D¡D¡D¡D¡D
¡D¡D¡D¡D¡D
¡@(a1:a5 )(b1:b5)

¸Ó¦p¦óÅã¥Ü¥X¦³­ÈªºÀx¦s®æ½d³ò¡H³Ò·Ð¦U¦ì´£¥X·N¨£¡I

¦^´_ 1# THEEND5912

­Y¥u¦³¤@³sÄò°Ï¶¡
D1="A1:A"&COUNTA(A:A)
E1="B1:B"&COUNTA(B:B)
1.jpg
2012-3-7 23:11

TOP

ÁÂÁ±zªº¦^ÂСA

§Ú·Q§â§Úªº°ÝÃDÁ¿±o²M·¡¤@ÂI¡A
¥Ø¼Ð¬O§Q¥Î trend »yªk¹w´ú­È¡AÁ|¨Ò¡Gx1:x200={trend(a1:a100,b1:b100,c1,200,,)}
a1:a100¡Bb1:b100¬O¤wª¾ªº¿é¤J­È¡A¦ý¥Ñ©ó¸ê®Æ¦³®ÉµLªk¶ñº¡¡A
³y¦¨a1:a100¡Bb1:b100¤¤¦³ªÅ®æ²£¥Í¡A¨Ï±otrend²£¥Í#VALUE!
·Q¸Ñ¨M³o­Ó°ÝÃD¡A½Ð¦U¦ì«e½úµ¹ÂI·N¨£!

TOP

¦^´_ 3# THEEND5912

=INDIRECT("A1:A"&COUNTA(A1:A100))
=INDIRECT("B1:B"&COUNTA(B1:B100))

TOP

¥»©«³Ì«á¥Ñ Hsieh ©ó 2012-3-8 08:29 ½s¿è

¦^´_ 3# THEEND5912
¦]¬°°}¦C¥²¶·¬°³sÄòÀx¦s®æ½d³ò
©Ò¥H¡A³o¼Ëªº¸ê®Æ¥²¶·§Q¥Î»²§UÄæ§â¸ê®Æ¶°¤¤«á¦A­pºâ
«Øij¤W¶ÇÀÉ®×¥H¤è«K´ú¸Õ
¥HEXCEL»¡©ú½d¨Ò¬°¨Ò
¥¼©R¦W.png
2012-3-8 08:29
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 5# Hsieh


ÁÂÁ±zªº¦^ÂСA¹Á¸Õ±zªº¦^ÂЫá¹J¨ì¥H¤U°ÝÃD¡G
trendªº½d³ò§Æ±æ¬O©T©wªº(©ÎªÌ·|¦Û°Ê½Õ¾ã)¡A¦]¬°¿é¤J¸ê®Æ°Ï¦³®ÉµLªk¶ñº¡(EX:¦³®É100¦C¡B¦³®É50¡B¦³®É200¡AµLªk©T©w)¡A
­Y³]©w½d³ò¬°A1:A200¡A«h·í¿é¤J¦C¤p©ó200¦C®É´N·|²£¥Í¿ù»~¡A·Q¸Ñ¨M³o­Ó°ÝÃD!
1.png
2012-3-8 11:33

TOP

¥»©«³Ì«á¥Ñ register313 ©ó 2012-3-8 23:23 ½s¿è

¦^´_ 6# THEEND5912

1.jpg
2012-3-8 23:23

TOP

¦^´_ 6# THEEND5912

=TREND(OFFSET($D$4,,,COUNT($B:$B),),OFFSET($B$4,,,COUNT($B:$B),)^{1,2,3,4,5,6},OFFSET($F$4,,,COUNT($F:$F),)^{1,2,3,4,5,6})
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

·PÁ¨â¦ì«e½úªº¦^ÂСA°ÝÃD¤w¸Ñ¨M¡C

TOP

        ÀR«ä¦Û¦b : ¹ï¤÷¥À­nª¾®¦¡A·P®¦¡B³ø®¦¡C
ªð¦^¦Cªí ¤W¤@¥DÃD