+ Reply to Thread
Results 1 to 3 of 3

Dynamic name range in excel 2007

  1. 09-27-2007, 05:35 AM #1
    age
    age is offline
    Registered User
    Join Date
    03-18-2005
    Posts
    36

    Dynamic name range in excel 2007

    Hi,

    I'am trying to make a Dynamic Pivot tabel. But I have problems with the offset formula in the "Name a range" tool (I use excel 2007). This is the formula I use:

    =OFFSET(Timer til fakturering!$A$1,0,0,COUNTA(Timer til fakturering!$A:$A),11)

    I get a forumla error on this: $A$1,0,0,COUNTA

    How can I resolve this?

    Thanks
    Last edited by age; 09-27-2007 at 08:34 AM.
    Reply With QuoteRegister To Reply
  2. 10-05-2007, 04:48 PM #2
    Lotus123
    Lotus123 is offline
    Forum Contributor Lotus123's Avatar
    Join Date
    11-07-2005
    Location
    Texas
    MS-Off Ver
    2007
    Posts
    153
    =OFFSET('Timer til fakturering'!$A$1,0,0,COUNTA('Timer til fakturering'!$A:$A),11)

    Maybe?

    Just looking for the easy solution first...you're missing the single quotes around your sheet names.
    Reply With QuoteRegister To Reply
  3. 10-06-2007, 12:19 PM #3
    age
    age is offline
    Registered User
    Join Date
    03-18-2005
    Posts
    36

    Wink

    Hi,

    Thanks Lotus123, the solution to my problem was;

    =OFFSET('Timer til fakturering'!$A$1;0;0;COUNTA('Timer til fakturering'!$A:$A);11)

    Thanks all,

    Age
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1