Learn to use the powerful QUERY function in Google Sheets for SQL-like data manipulation.
Help me write a QUERY function in Google Sheets: **Data Source:** - Data range: [e.g., Sheet1!A1:F1000] - Column headers: [list column names A through F] - Data types: [text, numbers, dates for each column] **Query Requirements:** [Describe what you want to retrieve in plain language] **Specific Operations:** - [ ] SELECT specific columns - [ ] WHERE conditions (filtering) - [ ] ORDER BY (sorting) - [ ] GROUP BY (aggregation) - [ ] PIVOT (cross-tabulation) - [ ] LIMIT results - [ ] LABEL columns - [ ] FORMAT output **Query Details:** - Columns to display: [e.g., A, B, D] - Filter conditions: [e.g., where C > 100 and B = 'North'] - Sorting: [e.g., by column D descending] - Grouping/aggregation: [e.g., sum of D by B] **Dynamic Elements:** - Filter value from cell: [Yes/No - which cell] - Date range from cells: [Yes/No] - Handle blank results: [Yes/No] Please provide: 1. Complete QUERY formula 2. Breakdown of each clause 3. How to reference cells in the query 4. Common syntax issues and solutions 5. Performance tips for large datasets 6. Alternative approaches when QUERY is limited
Or press ⌘C to copy