Perhaps it would be simpler/quicker to just add a header row, then
autofilter on col A for rows < 0, and copy paste the filtered rows to
another sheet. Then over there, just put in say, C6: =STDEV(B2:B6) and copy
down
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"Carlos" wrote in message
...
Hi Max,

First of all thanks for your advice. I'm afraid I did not give more detail
of what my problem is.

To give you more idea of what my goal is all about, say I limit my
criteria
to 5 consecutive instead of the 40 (to shorten my example below). Column
C
to analyze the 5 consecutive results ignoring Column A with zero :
A B C
1 15
2 20
3 10
0 20
4 10
5 20 5.00 =STDEV(B5:B6,B1:B3)
0 15 blank because A7=0
6 10 5.48 =STDEV(B8,B5:B6,B2:B3)
7 20 5.48 =STDEV(B8:B9,B5:B6,B3)
0 30 blank because A10=0
8 25 6.71 =STDEV(B11,B8:B9,B5:B6)
etc.

I hope you get what I mean.

Any further help will be appreciated.

Thanks.

Carlos