let me explain what 不提也罷 said

It is best to do in Excel's visual basic.
But 不提也罷's idea will work.
1) enter your data say in cells A1 to A40000
2) enter 1 in B1,
3) select B1 to B40000, Edit _> Fill -> Series -> step value set to 1
4) in cell C100 enter:
=IF((RIGHT(B100,2))="00","y","n")
5) in cell D100 enter:
=IF((C100="y",STDEV(A1:A100),"")
6) select C100 to D40000, press Crtl-D ti fill the formula.
7) move block A1:D40000 to where you want, i.e. enter headers, only when you finish all the steps above.
8) if you want to display only the stdev, do this:
select C100 to D40000, Data -> sort -> sort by Column C -> Decending

所有跟帖： 

• 對的，問題是選100個數據的問題。用R1C1相對地址，就沒問題了。 -不提也罷- ♂ (0 bytes) () 07/18/2006 postreply 07:47:07

• 但是有一個問題了 -4p大戰- ♂ (118 bytes) () 07/18/2006 postreply 07:59:54

• 回複：但是有一個問題了 -不提也罷- ♂ (62 bytes) () 07/18/2006 postreply 08:17:21

• 對對對，絕對地址能成 -不提也罷- ♂ (0 bytes) () 07/18/2006 postreply 09:12:35

• 又學了一把, 牛人真多. 嗬嗬 -老靴- ♂ (0 bytes) () 07/18/2006 postreply 09:15:37