Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Dynamic Range Problem
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 |
#2
|
|||
|
|||
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 wrote in message oups.com... 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 |
#4
|
|||
|
|||
If it is always one extra row just subtract 1
=offset(cell,0,0,counta(range)-1,5) Regards, Peo Sjoblom " wrote: 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 |
#5
|
|||
|
|||
Thanks very much for your help. I did insert data in row 2000 while
testing!!! Problem solved PL |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Passing a range name as an argument to the Index Function | Excel Discussion (Misc queries) | |||
named range refers to: in a chart | Excel Discussion (Misc queries) | |||
HTML_Control Range name | Excel Discussion (Misc queries) | |||
Paper Tray selection Problem, | Excel Discussion (Misc queries) | |||
Named dynamic ranges, copied worksheets and graph source data | Charts and Charting in Excel |