Hi..
I am having some moving spreadsheet data to a different tab, when
selecting rows according to input in a certain column; this input is made
of a 2 digit figure with a Capital letter and a number (something like M3,
F4, X5, etc..);
I initially tried the template "fill-in the blank"-style with no success
and changed over to "basic query" - still nothing worked;
I've tried back-quotes, single quotes, triple double quotes with no
success;
Something like:
=if(Len (B1)=0, "Inserir nº Caixa pf/Please insert Box nr em B1",query('Armazem
Total'!A2:R,"Select * Where B="&B1&" "))
which worked fine for single numbers..
Then I tried this:
=if(Len (B1)=0, "Inserir nº Caixa pf/Please insert Box nr em B1",query('Armazem
Total'!A2:R,"Select * Where B="""&B1&""" "))
then this
=if(query('Armazem Total'!A2:R,"Select * Where B="'&B1&'" "))
and
=if(query('Armazem Total'!A2:R,"Select * Where B="`&B1&`" "))
Then simplified to:
=query(!A1:F7, "Select * where B=`2F`")
And no luck so far.
Any ideas?
Thanks!!
b.
--
You received this message because you are subscribed to the Google Groups
"Google Visualization API" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/google-visualization-api.
To view this discussion on the web visit
https://groups.google.com/d/msgid/google-visualization-api/9174f051-cbae-4fa6-91bc-bbe12eaf9594%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
