+ Reply to Thread
Results 1 to 4 of 4

Dynamic range with INDEX

  1. #1
    Forum Contributor
    Join Date
    07-13-2017
    Location
    Hong Kong
    MS-Off Ver
    MS Office 2016
    Posts
    276

    Dynamic range with INDEX

    Hi all,

    I frequently use INDEX to create dynamic ranges. Though, so far I have only used e.g.

    Please Login or Register  to view this content.
    Can this be expanded to below, where I basically use two INDEX functions to create a range?

    Please Login or Register  to view this content.
    The dynamic range should refer to DA$1502:EC$1502 in the above example...

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Excel 2007
    Posts
    15,158

    Re: Dynamic range with INDEX

    Yes, have you tried that?

    Pete

  3. #3
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    18,237

    Re: Dynamic range with INDEX

    That formula will refer to $DA$1502:$EC$1502, not sure how it's dynamic though.
    If posting code please use code tags, see here.

  4. #4
    Forum Contributor
    Join Date
    07-13-2017
    Location
    Hong Kong
    MS-Off Ver
    MS Office 2016
    Posts
    276

    Re: Dynamic range with INDEX

    ups... had a typo in my formula. Thanks guys! Maybe it's time to get a nap and de-clutter my mind

    *it is only dynamic in my case not in the above example

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1