Consolidated Executive Summary - 05-2021 May - Working Copy.xlsx | |||
---|---|---|---|
AK | |||
39 | WALGREENS CONSOLIDATED | ||
40 | CVS Pharmacy | ||
41 | Rite Aid | ||
42 | Discount Drug Mart | ||
Other Tables |
Cell Formulas | ||
---|---|---|
Range | Formula | |
AK39:AK42 | AK39 | =FILTER($AK$5:$AK$29,$AL$5:$AL$29=$AK$31) |
Dynamic array formulas. |
In the dynamic array above, a result of the FILTER function, four items are returned. I might get one item or ten items as a result of this FILTER function.
How can I enter a formula that will pick up after the last line of the result of my FILTER function? i.e., if I have four items returned, I want to begin my next FILTER function in row 43. If the FILTER function returns 10 items, I want the next line after, row 49.