Category "google-query-language"

Do not retrieve query if empty output

In this sheet I'm working on, I'd like only the applicable data to show on the Teacher1Results tab, not the #N/A for empty output. Secondly, is it possible to m

Find lowest value matched from an Index/Match of an array

Example Spreadsheet Current formula not returning values as desired: =IFERROR(ifNA(min(arrayformula(index(D2:I2, match(INDEX(FLATTEN(split(A2, ", ", FALSE)&

Query formula not working with error AVG_SUM_ONLY_NUMERIC

I am getting this error on my query. Unable to parse query string for Function QUERY parameter 2: AVG_SUM_ONLY_NUMERIC I don't understand whats the problem is

How to get max values for each unique value in a different column in Google Sheets?

I have two columns, the first column (A) has names and the second column (B) has values. A B apple 10 orange 12 orange 14 apple 8 Is there a way to get only r

Google Sheets linking two sheets using a primary key

I have two sheets that I want to link using a "primary key". At the moment, I have imported from sheet1 into sheet2 some columns using the function =Sheet1!A1