Hello there!
I've searched everywhere for a solution, hoping you all can lend a hand. I have a long list of dates and associated information that cannot be sorted or filtered, but that I need to manipulate nonetheless. To get around this, I have a formula that will create a new list of dates from oldest to newest that fall between a user-specified specified range (CHART!F8 and CHART!F7 are the end and start dates):
{=iferror(((SMALL(IF(($H:$H<=CHART!$F$8)*($H:$H>=CHART!$F$7),$H:$H,"H"),ROW(H1)))),"")}
I copy this however many times down a column and it appears to work fine on its own to grab the appropriate dates from H, but I can't figure out how to get the associated information from the original table that corresponds to each date, to build basically a filtered clone of the original table. The only things I can think to do are either somehow nestle the above formula in OFFSET and capture the info I need in the 'width' section, or use ADDRESS or CELL or something to get the cell location of the formula result and use that in an OFFSET formula. The problem is I can't get either to even come close to working.
Hopefully that made sense, thanks again for any assistance.
Bookmarks