Max,

Appreciate your advice. I have thought of this before posting to the group.
I would have around 20 worksheets in one file and each worksheet would
contain thousands of records. I have found this approach time consuming.

Carlos

"Max" wrote:

> 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" <Carlos@discussions.microsoft.com> wrote in message
> news:965E1550-A650-4AFF-A149-2376AC9D6D1C@microsoft.com...
> > 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
>
>
>