N
N
nickostyle2020-01-31 18:14:43
Google Sheets
nickostyle, 2020-01-31 18:14:43

How to display table rows for a specific word on a separate sheet?

There is a table of the form (Google tables):

1. Vasya - 12 years old - Smartphone - Buyer - City
2. Nadia - 30 years old - Desktop - Seller - Village
3. Zhenya - 24 years old - Smartphone - Seller - City

And so on. The data comes from a google form. Task: display on a separate sheet only those lines that contain the word "Smartphone". Those. there should be a table on sheet 2:

1. Vasya - 12 years old - Smartphone - Buyer - City
3. Zhenya - 24 years old - Smartphone - Seller - City

Enter the formula
=FILTER('Responses to the form (1)'!A2:N120;N2 :N120="Smartphone") and get an error.

Answer the question

In order to leave comments, you need to log in

1 answer(s)
A
Alexander Ivanov, 2020-01-31
@nickostyle

Maybe,

=FILTER('Ответы на форму (1)'!A2:N120;'Ответы на форму (1)'!N2:N120="Смартфон")

will work.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question