Answer the question
In order to leave comments, you need to log in
How to sort the output of a query?
You need to sort a column for the presence of words from a dictionary from another sheet.
What it looks like for me
=QUERY(DB!A1:P1000;"select B,C,D,O,P where P like '9%' AND NOT UPPER(B) LIKE UPEER('"&badD!B1&"')" ;1)
But the condition AND NOT B LIKE '"&badD!B1&"'"; does not work, at least put the whole column, at least the range, how you can sort the list into words that are in the dictionary
And the word can both find at the beginning of the line and at the end
I tried to collect on another sheet and substitute NOT B LIKE '% Good%' AND NOT B LIKE '% Here%' AND NOT B LIKE '% Put%'
Maybe someone knows?
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question