Board logo

¼ÐÃD: ½Ð±Ð«ç»ò§ì¨ú¨â­Ó±ø¥ó¤Uªº¥þ³¡¼Æ¦r¡AµM«á°µ²Î­p? [¥´¦L¥»­¶]

§@ªÌ: winston219    ®É¶¡: 2010-9-4 13:18     ¼ÐÃD: ½Ð±Ð«ç»ò§ì¨ú¨â­Ó±ø¥ó¤Uªº¥þ³¡¼Æ¦r¡AµM«á°µ²Î­p?

·Q§ì¨ú¨C­Ó¦WºÙ¤U¡A¤À¦~¤ë«á°µ¤@²Î­p¸ê®Æ
¦pªþ¥ó¡A·PÁ¤j¤j!
§@ªÌ: Hsieh    ®É¶¡: 2010-9-4 14:27

H2°}¦C¤½¦¡
{=STDEV(IF(($A$2:$A$24=F2)*(--LEFT($B$2:$B$24,6)=G2),$C$2:$C$24))}
§@ªÌ: winston219    ®É¶¡: 2010-9-4 15:38

¸Õ¤F«Ü¤[¡A¦ý¶K¤W¥hH2¨S¤ÏÀ³¡A¬O§Ú¨ºùا˿ù¤F?³Â½Ð¤j¤j«ü¥¿!
§@ªÌ: winston219    ®É¶¡: 2010-9-4 15:42

¦^´_ 3# winston219


      «¢¡A§Ú§ä¨ì°ÝÃD¤F¡A¬O­n«öCTRL+SHIFT+ENTER ¤~¯à§¹¦¨¿é¤J¡A·PÁ¤j¤j¤X¡A§Ú¦³ÃÙ§U½×¾Â®@¡A¤]½Ð¤j®aª©¤Í¦@Á¸²±Á|¡A¤Ó·PÁ¤F!




Åwªï¥úÁ{ ³Â»¶®a±Ú°Q½×ª©ª© (http://forum.twbts.com/)