4

I'm trying to select certain data from responses of a form on a google sheet. I just want to select all the data if one cell is equal to a specific word. I've created a new sheet inside the same archive, and tried with several formulas:

=QUERY("respuestas!A2:M50","select * where G = 'Felino'")

setting name range respuestas!A2:M50 = raw:

=QUERY(raw,"select * where G = 'Felino'")

importing range:

=QUERY(importrange("https://docs.google.com/spreadsheets/d/1y1WxrJ9ErkqX1gR5su37dAPe97fI9KZoeQtxhuSC2lA/edit","respuestas!A2:M50"),"select * where G = 'Felino'")

importing range with name range:

=QUERY(importrange("https://docs.google.com/spreadsheets/d/1y1WxrJ9ErkqX1gR5su37dAPe97fI9KZoeQtxhuSC2lA/edit","respuestas!A2:M50"),"select * where G = 'Felino'")

and trying with Col1 attribute instead Column name, like A2, in the select property. Also trying to select just a column like: 

"select A"

or

"select Col1""

and none of these works...

I dont know what else to try??

Rubén
  • 34,714
  • 9
  • 70
  • 166
isk27
  • 329
  • 2
  • 5
  • 13
  • 8
    What is your locale? Have you tried `;` instead of `,` between your parameters? – Aurielle Perlmann Oct 14 '17 at 03:17
  • 2
    The first one should be `=QUERY(respuestas!A2:M50, "select * where G = 'Felino'")`, no quotation mark around the range. The importrange version can only work with Col1. But if no query work at all, maybe indeed you switched the locale and need to use semicolons for separating arguments. –  Oct 14 '17 at 03:18
  • 1
    The semicolon works! thanx – isk27 Oct 14 '17 at 03:31

1 Answers1

5

Ohh that works!!

Thanx...

It was just the semicolon... I've replaced ":" with ";"

isk27
  • 329
  • 2
  • 5
  • 13