Results 1 to 9 of 9
  1. #1
    New Lounger
    Join Date
    Sep 2005
    Location
    Calgary, Alberta, Canada
    Posts
    10
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: the offset function (Excel 2003)

    I have figured it looked hard then it was

  2. #2
    New Lounger
    Join Date
    Sep 2005
    Location
    Calgary, Alberta, Canada
    Posts
    10
    Thanks
    0
    Thanked 0 Times in 0 Posts

    the offset function (Excel 2003)

    [i]Post deleted by Allen[/i
    I am new to the offset function currently learnign the basics on excel help, anyone know of the advanced uses for it. I am using to to populate a table from another table

  3. #3
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: the offset function (Excel 2003)

    Hi and welcome to the lounge!

    I noticed your original post before you deleted it. I don't think that the offset function should be used it that context!

    Anyways...hope to see ya around again!

    PS: Its best not to delete posts, as it removes the context of any replies attached to it. Editting the post with an addendum is a better alternative!
    Cheers
    Regards,
    Rudi

  4. #4
    New Lounger
    Join Date
    Sep 2005
    Location
    Calgary, Alberta, Canada
    Posts
    10
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: the offset function (Excel 2003)

    is the offset function a good way of transfering data to another table if a certain conditions met?

    sorry I figured I could of removed my useless question before other could see it, this place gets fast response though,

  5. #5
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: the offset function (Excel 2003)

    That depends entirely on what you need the spreadsheet to do. I still do not believe the offset function is useful in populating another table. You may as well copy the table data from the source table and paste with a link then!

    Can you be more specific in what you need to achieve?
    Regards,
    Rudi

  6. #6
    New Lounger
    Join Date
    Sep 2005
    Location
    Calgary, Alberta, Canada
    Posts
    10
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: the offset function (Excel 2003)

    Yes, I could attach my project and describe it. I''ll just have to make it a smaller file, im over my 100 k limit

  7. #7
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: the offset function (Excel 2003)

    If the .xls file is too big, create a .zip file from it.

  8. #8
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: the offset function (Excel 2003)

    >>> anyone know of the advanced uses for it.

    Here is one or two advanced uses for the OFFSET function!

    1.
    Dynamic Named Ranges

    Named ranges are among the most powerful features of Excel, especially when used as the source range for list controls, PivotTables, or charts. A problem arises, however, when the contents of a list change often. It would be a problem to have to redefine your named ranges every time a table has records added or removed. The solution is to create a range that will automatically adjust based on the number of items in the list.

    First, create a list in column A of a worksheet. From the worksheet's Insert menu choose Names then the Define.... Enter a name for your new range, such as MySheet!rngDynamic. Then, in the
    Regards,
    Rudi

  9. #9
    Star Lounger
    Join Date
    Feb 2003
    Posts
    89
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: the offset function (Excel 2003)

    An alternative to OFFSET and COUNTA,

    =$A$1:INDEX($A$1:$A$65536,MATCH(9.99999999999999E+ 307,$A$1:$A$65536))

    for numeric data

    =$A$1:INDEX($A$1:$A$65536,MATCH(REPT("z",255),$A$1 :$A$65536))

    for text data

Posting Permissions

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