EXCEL FILTER FUNCTION

Copper Contributor

I am attempting to set up a spreadsheet that will stack the results of a filter function on top of each other.

The difficulty I am finding is that the results can be of various row numbers therefore how do I input the formula so that it starts a new filter at the bottom of the old filter ending?

1 Reply

It is hard to give a universal answer but it sounds like you are try something that will need a compound formula. Probably use LET to find set A and set B then the counts nA and nB and then create a sequence (s) as Sequence(nA+nB). Then you should be able to do something like:
IF(s<=nA, index(A,s), index(B,s-nA) )
so basically you create a new list that picks each value from A for all of A then each value from B