Top "Google-sheets-query" questions

Use this tag for Google Sheets questions that involve the use of spreadsheet formulas.

Extracting the top five maximum unique values

I am running a Nerf league at a party and want my spreadsheet to show the top five contestants. Contestants …

google-sheets max filtering google-sheets-query
Documentation for ticker symbols supported by googlefinance function in Google Sheets

The GOOGLEFINANCE function in Google Sheets allows you to lookup the price (or other attribute) of a stock or instrument. …

regex google-sheets google-sheets-formula google-sheets-query google-finance
ImportRange Function to Ignore Empty Cells

I want to import a range from another Google sheet, but to ignore empty cells so that the data prints …

google-sheets google-sheets-formula google-sheets-query google-query-language importrange
Query returning error Unable to parse query string for Function QUERY parameter 2: NO_COLUMN

I am currently working in the following spreadsheet https://docs.google.com/spreadsheets/d/13KfjUhWSB-BjGyC1G8f8i8o4SPd1…

google-sheets google-sheets-formula google-sheets-query google-query-language importrange
Google Sheets query date > today()

I'm trying to filter out dates greater than today. I looked up the syntax but the date-part does not work; …

datetime google-sheets google-sheets-query