sort filter formula with exclusion

[valmir]

Hi everyone!
I have this formula here that I want to add an exclusion to:
=SORT(FILTER(INDEX($Q$1:$V$704;SEQUENCE(ROWS(Q1:Q704));{1\2\3\4\5\6});$V$1:$V$704<>0);{6;5};{-1;1})
In my particular case, in the third column (represented by number 3 in the formula) I have names (text) and I want to exclude all names that include the word "missing"
Please note that I don't have the word "missing" as a whole, I have may words that include "missing" in them.
Is that possible?
Thanks in advance!

 

[Fluff]

How about

=SORT(FILTER($Q$1:$V$704;($V$1:$V$704<>0)*(ISERR(SEARCH("missing";s1:s704))));{6;5};{-1;1})

 

[valmir]

How about

=SORT(FILTER($Q$1:$V$704;($V$1:$V$704<>0)*(ISERR(SEARCH("missing";s1:s704))));{6;5};{-1;1})

Oh Mr. Fluff, saving my day once again! Thanks a lot!

 

[Fluff]

You're welcome & thanks for the feedback.

 

[valmir]

Mr. Fluff, if you don't mind, I'm trying to replicate your formula, but I'm getting a spill of 8 columns to the right? Is that because in this formula the numbers are not in sequence?
This is the original formula:
=SORT(FILTER(INDEX($A$5:$P$48;SEQUENCE(ROWS(A5:A48));{1\2\15\8\10\12\14\16});$P$5:$P$48<>0);{8;3};{-1;1})
This is the one I came up with:
=SORT(FILTER($A$5:$P$48;($P$5:$P$48<>0)*(ISERR(SEARCH("missing";B5:B48))));{8;3};{-1;1})

 

[Fluff]

If you only want some of the columns you need to use

=SORT(FILTER(CHOOSECOLS($A$5:$P$48;1;2;15;8;10;12;14;16);($P$5:$P$48<>0)*(ISERR(SEARCH("missing";B5:B48))));{8;3};{-1;1})

 

[valmir]

If you only want some of the columns you need to use

=SORT(FILTER(CHOOSECOLS($A$5:$P$48;1;2;15;8;10;12;14;16);($P$5:$P$48<>0)*(ISERR(SEARCH("missing";B5:B48))));{8;3};{-1;1})

Exactly! Thanks once again!

 

[Fluff]

My pleasure.