EXCEL FILTER FUNCTION

%3CLINGO-SUB%20id%3D%22%5C%26quot%3Blingo-sub-3167407%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3EEXCEL%20FILTER%20FUNCTION%26lt%3B%5C%2Flingo-sub%26gt%3B%3CLINGO-BODY%20id%3D%22%5C%26quot%3Blingo-body-3167407%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CP%3EI%20am%20attempting%20to%20set%20up%20a%20spreadsheet%20that%20will%20stack%20the%20results%20of%20a%20filter%20function%20on%20top%20of%20each%20other.%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3EThe%20difficulty%20I%20am%20finding%20is%20that%20the%20results%20can%20be%20of%20various%20row%20numbers%20therefore%20how%20do%20I%20input%20the%20formula%20so%20that%20it%20starts%20a%20new%20filter%20at%20the%20bottom%20of%20the%20old%20filter%20ending%3F%26lt%3B%5C%2FP%26gt%3B%26lt%3B%5C%2Flingo-body%26gt%3B%3CLINGO-LABS%20id%3D%22%5C%26quot%3Blingo-labs-3167407%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CLINGO-LABEL%3EExcel%26lt%3B%5C%2Flingo-label%26gt%3B%26lt%3B%5C%2Flingo-labs%26gt%3B%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3C%2FLINGO-SUB%3E
Occasional Visitor

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