Thanks Thanks:  0
Likes Likes:  0
Page 2 of 2 FirstFirst 12
Results 11 to 13 of 13

Thread: DYNAMIC NAMED RANGE

  1. #11
    Board Regular
    Join Date
    Feb 2002
    Location
    Las Vegas Nevada USA
    Posts
    239
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    By the way my table starts in row 6o and instead of =OFFSET(INPUT!$A$1,0,EndRow,6) I used $A$60 instead.
    George

    Learn to listen. Opportunity sometimes knocks very softly.

  2. #12
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    83,657
    Post Thanks / Like
    Mentioned
    33 Post(s)
    Tagged
    6 Thread(s)

    Default

    On 2002-05-03 13:00, GeorgeB wrote:
    By the way my table starts in row 6o and instead of =OFFSET(INPUT!$A$1,0,EndRow,6) I used $A$60 instead.
    =OFFSET(INPUT!$A$60,0,EndRow-59,6)

    will do. In other threads, I added an additional mechanism to variablize that minus 59 bit.

    The most important thing is that the defined name, when that name must be used with Pivot Tables, D-functions (DSUM, etc), Advanced Filter, includes the row that houses the labels/column headings.

    Aladin



    [ This Message was edited by: Aladin Akyurek on 2002-05-03 13:40 ]

  3. #13
    Board Regular
    Join Date
    Feb 2002
    Location
    Las Vegas Nevada USA
    Posts
    239
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    You're the man Aladin. Thanks again.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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