Results 1 to 2 of 2
  1. #1
    Star Lounger
    Join Date
    Apr 2001
    Location
    SOUTH AFRICA
    Posts
    74
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Range name using offset (excel 97)

    Hi ALL,
    Please help again. I want to name a range using the offset formula = offset(sheet1!$a$1,0,0,counta(sheet1!$a:$a),2), but I don't want to include the last row of the range. ie:
    red 2
    blue 1
    green 4
    Total 7
    I don't want the total row as I want to graph the data.

    Thanks

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Range name using offset (excel 97)

    I would use:

    <pre>=OFFSET(Sheet1!$A$1,0,0,MAX(1,COUNTA(Sheet1!$ A:$A)-1),2)
    </pre>

    Legare Coleman

Posting Permissions

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