Prev: UNABLE TO SAVE FORMATTING
Next: Return range of cell values based on current date
From: Marcelo on 30 Mar 2010 17:33
replace the v90 for the INDIRECT("v"&MATCH(SMALL(W:W;1),W:W,0)+5)

sorry
--
pleae click yes if it was helpfull
regards from Brazil
Marcelo



"Marcelo" escreveu:

> try this
>
> =STDEVP((INDIRECT("v"&MATCH(SMALL(W:W;1),W:W,0)+1)):V90)
>
> hth
> --
>
> pleae click yes if it was helpfull
> regards from Brazil
> Marcelo
>
>
>
> "GK" escreveu:
>
> > Hi Group,
> > I'm having difficulties finding a way that will automate my
> > calculation of Standevp as shown in image (Column AC).
> > The variable is the starting date of the Monthly Performance as shown
> > in image (Column V)
> >
> > What I'm looking for is a way that automatically finds the starting
> > point for that calculation so I don't have to go into each tab and
> > manually change the starting date.
> >
> > The image is located in this post i just created.
> > http://excelproblems.wordpress.com/2010/03/30/hello-world/
> >
> > Thanks for your help.
> > .
> >
 | 
Pages: 1
Prev: UNABLE TO SAVE FORMATTING
Next: Return range of cell values based on current date