Results 1 to 5 of 5

INDIRECT and dynamic ranges

Threaded View

inky INDIRECT and dynamic ranges 11-28-2007, 06:17 AM
daddylonglegs I'd normally try to avoid... 11-28-2007, 06:45 AM
inky so that will handle the... 11-28-2007, 08:14 AM
daddylonglegs The ranges within the SUMIF... 11-28-2007, 08:44 AM
inky thanks daddylonglegs. i... 11-28-2007, 04:08 PM
  1. 11-28-2007, 06:17 AM #1
    inky is offline
    Forum Contributor
    Join Date
    09-19-2007
    Posts
    115

    INDIRECT and dynamic ranges

    i tried to use the INDIRECT function to refer to a cell that contains the name of a dynamic range, to only discover that INDIRECT and dynamic ranges do no work! any suggestions for a work-around in a formula?

    so far i've tried to determine the starting and ending cells of the range for a particular element (eg interest) as detailed in the attached example by determine starting cell, count fields to determine ending cell then using the ADDRESS function to convert it into a R1 format (yellow cells), then INDIRECT to the cell containing the "range" (green cell), yet this seems cumbersome.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« 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