Re: Display Dynamic Range

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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 *** 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




.

Quantcast