N
N
None22020-02-25 17:18:59
Google Sheets
None2, 2020-02-25 17:18:59

How to copy lines from an adjacent sheet, one of the cells of which matches the condition?

There is a table with data, you need to copy completely rows to another sheet according to a certain condition (one of the cells must have a certain text).

Answer the question

In order to leave comments, you need to log in

1 answer(s)
N
Noir, 2020-02-25
@None2

=filter(sheet1!A:L;sheet1!A:A="text");

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question