Offset Situation

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,
I have named a range Database, my worksheet is also called database. Problem
arises it selects two columns past any data or column headings. This causes a
problem in my pivot table. So what is wrong with this function? Thank you!
=OFFSET(Database!$A$1,0,0,COUNTA(Database!$A:$A,1),COUNTA(Database!$1:$1))
 
You must log in or register to reply here.

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

Dynamic range in Pivot table 4
Dynmic Range in pivot table 1
Trailing 30 days sum calculation with excel 1
Dynamic Range for multiple columns 7
Dynamically Naming a Table of Data 2
How I can set dynamic pivot table ONLY when I have enough data point 1
hLookup dynamic range 2
Dynamic Range Using INDEX instead of Offset 4

Back
Top