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.
Bookmarks