Categories: Sheets : Ask a "how-to" question :

Why do I get this error?

Showing 1-2 of 2 messages
Why do I get this error? aussie scott 4/30/12 4:31 PM
error: Invalid query: Column [Col2] does not exist in table.

With this formula

=ArrayFormula( QUERY( FILTER(CD!A:B ) ; "Select Col2 where Col2 >1" ; 0) )
Re: Why do I get this error? MarinusP 5/1/12 2:27 AM
Hi

Please try:

= QUERY( CD!A:B ; "Select B where B>1";0)

or

=FILTER( CD!B:B ; CD!B:B>1 )