G
G
grachev_goga2021-09-01 20:16:49
Google Sheets
grachev_goga, 2021-09-01 20:16:49

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

1 answer(s)
I
idShura, 2021-09-02
@grachev_goga

=QUERY(DB!A1:P1000;"select B,C,D,O,P where " & badD!G1)

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question