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