software

In C2:C65 I have dates as follows (DK standard):
01-01-01
01-02-01
01-03-01
etc.
indicating January 2001, February 2001, March 2001 and so on up to
01-04-06 (indicating April 2006) in cell C65. In about a fortnight new data will appear i C66: (01-05-06) and later on
C67: (01-06-06)
etc.

I know how to create a dynamic range if I always had to start from the top, but here I want to be able to enter for example 01-01-05
in cell H1 and the dynamic range should now be, not from the top, but from the cell C51 (which holds 01-01-05) and as far down as I
(just now) have data.

Hans Knudsen
I found out myself so please forget about it.
Hansquot;Hans Knudsenquot; gt; skrev i en meddelelse ...
gt; In C2:C65 I have dates as follows (DK standard):
gt; 01-01-01
gt; 01-02-01
gt; 01-03-01
gt; etc.
gt; indicating January 2001, February 2001, March 2001 and so on up to
gt; 01-04-06 (indicating April 2006) in cell C65. In about a fortnight new data will appear i C66: (01-05-06) and later on
gt; C67: (01-06-06)
gt; etc.
gt;
gt; I know how to create a dynamic range if I always had to start from the top, but here I want to be able to enter for example
gt; 01-01-05 in cell H1 and the dynamic range should now be, not from the top, but from the cell C51 (which holds 01-01-05) and as far
gt; down as I (just now) have data.
gt;
gt; Hans Knudsen
gt;
gt;