Answer the question
In order to leave comments, you need to log in
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
Maybe,
=FILTER('Ответы на форму (1)'!A2:N120;'Ответы на форму (1)'!N2:N120="Смартфон")
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question