software

Bottom Qtile410 is the answer (formula is =MIN(C386:C486) )
based on 52
weeks of entries,
each number
being a week.
C386 April 9/05
C486 April 9/06
Is it possible to have a formula that allows C386 to move to C387 amp; C486
moving to C487 as each week comes along.
C387 becomes April 16/05 C487 becomes April 16/06

Many Thanks
TAL
Don't know if I quite understand your question.

Can't you just copy the formula down the column, where the cell addresses in
the formula will *automatically* increment to the ranges that you're looking
for?

=MIN(C386:C486)
=MIN(C387:C487)
=MIN(C388:C488)

OR ... perhaps you're looking to keep the cells empty (blank) until data is
entered into the appropriate cells:

=IF(C486,MIN(C386:C486),quot;quot;)
And copy down as needed.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
quot;TALquot; gt; wrote in message
...
gt; Bottom Qtile 410 is the answer (formula is =MIN(C386:C486) )
gt; based on 52
gt; weeks of entries,
gt; each number
gt; being a week.
gt; C386 April 9/05
gt; C486 April 9/06
gt; Is it possible to have a formula that allows C386 to move to C387 amp; C486
gt; moving to C487 as each week comes along.
gt; C387 becomes April 16/05 C487 becomes April 16/06
gt;
gt; Many Thanks
gt; TAL
gt;
gt;