Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Dynamic range
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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Dynamic range
I found out myself so please forget about it.
Hans "Hans Knudsen" skrev i en meddelelse ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Drawing data from specific columns of a dynamic range | Setting up and Configuration of Excel | |||
Crate group of date, with Dynamic Range in pivot table not working | Excel Discussion (Misc queries) | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
How to dynamically reference a dynamic named range | Excel Worksheet Functions | |||
Reference to a dynamic range | Excel Discussion (Misc queries) |