CODEWITHSUNDEEP
sqlgoogle-sheetsgoogle-sheets-formulaarray-formulasgoogle-query-language
user9258693
user9258693

Reputation:

How to query results that don't contain the #N/A error in Google Sheets

I am trying to query results that don't contain #N/A results from another sheet in the same Google Sheets WorkSheet.

I have tried this formula but it won't work

=QUERY('Table 1'!A2:G500, "Select F Where G <> '#N/A'")

Tried several other ways but still in vain.

I need to select Column F where column G does not contain #N/A.

Please help if you might know how to go about this.

Upvotes: 7

Views: 12791

Answers (1)

player0
player0

Reputation: 1

try like this:

=QUERY('Table 1'!A2:G500, "select F where not G contains '#N/A'", 0)

or like this:

=ARRAYFORMULA(QUERY(IFERROR('Table 1'!A2:G500), "select Col6 where Col7 is not null", 0))

Upvotes: 11

Related Questions