|
Re: Two quick questions
Some corrections, sorry:
Lines
> With an initial date in A1, say: 01-Jul-2005
>
> Put in say, B1:
> =OFFSET(Sheet1!$A$1,INT((ROWS($A$1:A1)-1)/2),)
should read as:
With running dates filled in A1 down:
01-Jul-2005
02-Jul-2005
03-Jul-2005
04-Jul-2005
05-Jul-2005
06-Jul-2005
etc
Put in say, B1:
=OFFSET($A$1,INT((ROWS($A$1:A1)-1)/2),)
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <at>yahoo<dot>com
----
|