Hsieh

¦^´_ 1# icestormer


   

¤U¸ü (79.93 KB)

2012-7-30 15:08

Hsieh

¦^´_ 5# icestormer
D1=AVERAGE(C186:C279) ¥ý¥Î³o¤½¦¡ºâ²Ä¤@¦¸ªº¥­§¡­È
D2=AVERAGE(C188:C286)¦A®Ú¾Ú¤WÀYªº[6.89] ,±NC186:C235¤§¤¤¿ï¾Ü ¤ñ6.89ÁÙ°ªªº¼Æ­È ºâ¥­§¡­È(³o³¡¥÷¦n¹³±o¥Î¤W§ä¨ì²Å¦Xªº¼Æ­È«á¶Ç¦^¸Ó¦ì§},ªº¼Ë¤l)
D3=³Ì«á¦A¨Ì²Ä¤G¦¸¥­§¡ªº­È[6.81] ±qC186:C108 ºâ¥X²Ä¤T¦¸¥­§¡

¬Ý¤£À´§A¨C¦¸¥­§¡ªº½d³ò¦³¬Æ»ò³W«h?
´NµLªk±oª¾»P§Aªºµo°Ý¦³¦óÃöÁp?
¦Ü©ó§Axldownªº¤½¦¡
À³¸Ó¬O°}¦C¤½¦¡=INDEX($A$2:$A$171,MATCH(TRUE,$A$2:$A$171="",0)-1,)
¦Ó¤£¬O=INDEX($A$2:$A$171,MATCH(TURE,$A$2:$A$171="",0)-1,)

Hsieh

¦^´_ 9# icestormer

¤½¦¡¿ù»~¬O¦]¬°¥²¶·¨Ï¥Î°}¦C¤½¦¡¤~¯à¦¨¥\(Ctrl+Shift+Enter)

¸Õ¸Õ¬Ý
¥ý«Ø¥ß¤@­Ó¦WºÙrng
°Ñ·Ó¨ì¤½¦¡=OFFSET(§ó·s!$C$5,,,MATCH(TRUE,§ó·s!$A$5:$A$65536="",0)-1,)

¤U¸ü (24.09 KB)

2012-7-31 16:49

D1=AVERAGE(rng)
D2=SUMPRODUCT((rng<D1)*rng)/(COUNT(rng)-SUMPRODUCT((rng>=D1)*1))
D3=SUMPRODUCT((rng<D2)*rng)/(COUNT(rng)-SUMPRODUCT((rng>=D2)*1))   
EXCEL´ú¸Õ.zip (16 KB)

¤U¸ü¦¸¼Æ: 4

2012-7-31 16:52

Hsieh

¦^´_ 11# icestormer

¤U¸ü (278.05 KB)

2012-7-31 20:52

Hsieh

¦^´_ 15# icestormer
¸Õ¸Õ¬Ý
EXCEL´ú¸Õ.rar (14.11 KB)

¤U¸ü¦¸¼Æ: 3

2012-8-1 20:08