Data & Analysis Beginner

Google Sheets QUERY function-2

Write complex Google Sheets QUERY formulas to filter data tables.

👁️ 4995 views ❤️ 316 likes 📋 591 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