Data & Analysis Beginner

Google Sheets QUERY function-3

Write complex Google Sheets QUERY formulas to filter data tables.

👁️ 3581 views ❤️ 99 likes 📋 425 copies
The Prompt Template
Write a Google Sheets QUERY formula to extract data from a table in sheet '[SHEET_NAME]' (range A:Z). Filters: [FILTER_CONDITIONS: e.g. sales > 1000, date is this month]. Sort order: [SORT_COL]. Explain how the select statement works and how to handle empty results.

266 characters

Tags
#google-sheets #formulas #query
Works Best With
ChatGPT Gemini

Related Prompts