| Why do I get this error? | aussie scott | 12/04/30 16:31 | 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 | 12/05/01 2:27 | Hi Please try: = QUERY( CD!A:B ; "Select B where B>1";0) or =FILTER( CD!B:B ; CD!B:B>1 ) |