How to work around dynamic arrays as they resize?

[Tarver]

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.

 

[Norie]

Can you post the 2nd filter formula?

 

[Tarver]

Can you post the 2nd filter formula?

There isn't a specific filter formula. I'm simply looking for how to identify when the results of one are complete so the next formula can begin. For argument's sake, let's say the next formula I want to use here would be

=FILTER($AN$5:$AO$29,$AO$5:$AO$29=$AK$32)

Does that help?