Google Spreadsheet Post #1448
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. Dec-26, 2013
question by Isai Alvarado (http://productforums.google.com/forum/?zx=e80jmfn2nptg#!category-topic/docs/spreadsheets/urtd8hGGOvk)
Query formulas with cell references HELP
Hi,
If I type =query(PTS," "&E8&" ")
and E8 has select A,B,C where (A='P' and B<8 and C>=2), the formula works.
However, if E8 has a named range select A,B,C where (A='P' and B<"&csp&" and C>=2), it doesn't recognize the named range.
Is there a way to make the query function recognize the named range csp that is inside E8?
Example spreadsheet: https://docs.google.com/ spreadsheets/d/1k_kVqHjI_ 6oAqARq3zgieMpanfwTZJJIJCfxUqh oxxE/edit#gid=0
-------------------------------------------------------------------------------------------------
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. Dec-26, 2013
question by Isai Alvarado (http://productforums.google.com/forum/?zx=e80jmfn2nptg#!category-topic/docs/spreadsheets/urtd8hGGOvk)
Query formulas with cell references HELP
Hi,
If I type =query(PTS," "&E8&" ")
and E8 has select A,B,C where (A='P' and B<8 and C>=2), the formula works.
However, if E8 has a named range select A,B,C where (A='P' and B<"&csp&" and C>=2), it doesn't recognize the named range.
Is there a way to make the query function recognize the named range csp that is inside E8?
Example spreadsheet: https://docs.google.com/
-------------------------------------------------------------------------------------------------
No comments:
Post a Comment