Re: Display Dynamic Range
- From: "Turin" <scooplaw@xxxxxxxxxxx>
- Date: 28 Jun 2006 11:57:44 -0700
OK great. Getting there.
I still don't know how to DISPLAY the result without copying the
formula into each cell. The Daily_Postage array changes every day.
Daily Postage is 12 x 500 array of cells each with a formula or
reference in it. The days records show up across the 12 columns and
down as far as there's data, below that the formulas generate "" blank
cells. I want to copy the array of data only over to sheet 2.
Biff wrote:
BTW, your formula is incorrect:
=OFFSET(Daily_Postage_Range,0,0,COUNTIF('Import_Postage'!$A$A,">0",12)
Probably should be:
=OFFSET(Daily_Postage_Range,0,0,COUNTIF('Import_Postage'!$A:$A,">0"),12)
COUNTIF('Import_Postage'!$A:$A,">0") is the height argument
12 is the width argument
Biff
"Biff" <biffinpitt@xxxxxxxxxxx> wrote in message
news:eudLIthmGHA.3732@xxxxxxxxxxxxxxxxxxxxxxx
Hi!
It doesn't work like that!
You'd have to select an array of cells equal to:
COUNTIF('Import_Postage!$A$A,">0",12
Then enter the formula as an array.
Biff
"Turin" <scooplaw@xxxxxxxxxxx> wrote in message
news:1151431662.559187.142180@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
I created a dynamic named range(Daily_Postage) from data on
sheet1(Import_Postage) that basically includes only the rows that have
data. Works good. Now I want to display that new set of data on
sheet2 without spreading formulas around in each cell. Thought I could
=OFFSET(Daily_Postage_Range,0,0,COUNTIF('Import_Postage!$A$A,">0",12)
in A1 and see the whole array on sheet2 but no.
Help?
Tim
.
- References:
- Display Dynamic Range
- From: Turin
- Re: Display Dynamic Range
- From: Biff
- Re: Display Dynamic Range
- From: Biff
- Display Dynamic Range
- Prev by Date: Re: Help! Boss needs this ASAP - I am pulling out my hair here folks use of "&" in HEADER
- Next by Date: Re: HELP!
- Previous by thread: Re: Display Dynamic Range
- Next by thread: Re: Add formatting to all pages in workbook
- Index(es):
Relevant Pages
|
