How to filter all data except the selected word using a formula?

E

Eugene Dragan2021-05-17 23:17:25

Google Sheets

Eugene Dragan, 2021-05-17 23:17:25

How to filter all data except the selected word using a formula? An example of a document with an example of the result that I want to implement is attached.

Document

Thank you in advance for your help and answers.

Reply

Answer the question

In order to leave comments, you need to log in

1 answer(s)

G

Grigory Boev, 2021-05-18
@dragan2011

This is how you can:

=query(A3:A;"SELECT A WHERE A<>"&JOIN(" AND A<>";unique(FILTER("'"&C:C&"'";C:C<>""))))