Hi!
Im about to make a list that is a summery of two ranges. My two formulas will create ranges that may vary in rows but be the same amount of columns (3). What Im looking for is a way to have a joined formula including both ranges, and when the first is finished, the next one extend the list.
My first formula is complicated but is basically an extended =(A1:C10) (Both 1 and 10 will differ)
My second is a filter formula =FILTER(F1:H20;D1:D20), creating a range with three columns and the same amount of row as values in D1:D20.
Id like to think that a solution like =(A1:C10)(FILTER(F1:H20;D1:D20) would make a list with the outcomes of the two formulas, but it doesn't. Is there a way to merge these two lists using one formulas within one cell?
Thank you very much in advance!
Best wishes.
Nils
Bookmarks