Extract records with multiple criteria, slow recalc

[•Daniel•]

Hello I have this formula

=INDEX(TAB!$B$3:$B$5390,AGGREGATE(15,6,(ROW(TAB!$B$3:$B$5390)-ROW(TAB!$B$3)+1)/(--ISNUMBER(FIND($B$1:$F$1,TAB!$B$3:$B$5390))),ROWS(A$5:A5)))

List of codes = TAB!$B$3:$B$5390
List of strings to filer extract from list of codes = $B$1:$F$1

So my list of codes loook like this:

0101006-33-16407-TORRE

<tbody>
</tbody>

0101006-1738-15518-TORRE

0102005-6-6268-TORRE

<tbody>
</tbody>

What I do is type in the range $B$1:$F$1: 0101, 0102005

I use the formula and I get a list of all 0101.... and, 0102005.....

I repeat this in another column, this will be a column of exceptions, then I use a similar formula in a third column to get all of the 1st columns record minus the exceptions.

It all works fine except for the recalculation delay, is there a way or a different way in which I can speed this process, maybe with dynamic tables? or only trought VBA?

 

[•Daniel•]

I just realize I can have the following case,

I want all records which start with 0106, except the family of 0106009, but of that family of 0106009 I want to keep the 0106009-856 ones, so in my method I will add a column of exceptions to exceptions then in another column I will extract the exceptions records minus exceptions to exceptions, which will slow down my calculations further