1 minute to read - Mar 30, 2023

Compose Complex Spreadsheet Formulas

VISIT
Google Sheet formula which copies all rows from sheet1 where column "A" contains word "iphone"

Here is a formula that you can use to copy all rows from sheet1 where column "A" contains the word "iphone":

\=QUERY(Sheet1!A:Z, "SELECT \* WHERE A CONTAINS 'iphone'")

This formula will return a range of cells from Sheet1 that includes all columns (A:Z) and only the rows where column A contains the word "iphone". The result will be displayed in the cells where you enter the formula.

Note: This formula will only work if you have the QUERY function enabled in your Google Sheets. If you don't have the QUERY function enabled, you can enable it by going to "Data > Named and protected ranges" in the Google Sheets menu and then selecting "Query function" from the "Named ranges" dropdown.

I hope this helps! Let me know if you have any questions.

Article source
loading...