Dynamic Range Problem

P

plawrence

Hi ALL:
I created a dynamic range name Production that refers to the following
formula = offset('daily production output'!$a$1,0,0,counta('daily
production output'!$a$a),5)which is is to be used in a pivot table.
However when I enter data in the range, one row of blanks is always
selected along with row of data. Labels are in a1,b1 etc.
Any help will be appreciatedto solve this problem
 
B

Bernie Deitrick

PL,

You may have a seemingling blank cell somewhere way down column A on "Daily
production output" that is increasing the value returned by the counta.

HTH,
Bernie
MS Excel MVP
 
A

Aladin Akyurek

Would you specify which column from A:E is the most complete and of
numeric type?
 
G

Guest

If it is always one extra row just subtract 1

=offset(cell,0,0,counta(range)-1,5)


Regards,

Peo Sjoblom
 
P

plawrence

Thanks very much for your help. I did insert data in row 2000 while
testing!!!
Problem solved

PL
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

hLookup dynamic range 2
Dynmic Range in pivot table 1
Dynamic Range for multiple columns 7
automatically update pivot tables when dynamic named range is expa 10
Dynamic formula for Pivot Table 6
Dynamic range in Pivot table 4
Dynamically Naming a Table of Data 2
Dynamic Range (again) 7

Top