Fields Expansion


Whenever you can specify a number of fields, you can specify them either as (1) a range or as (2) ONE string with the fields separated by "," or ";". In the latter case, Spearian automatically expands the fields into columns.



1. Fields specified as a range

Example: =Q("MSFT",B1:C1,A2:A8)



2. Fields specified as a string separated by ";" or ","


Example: =Q("MSFT","DATE,ADJCLOSE",A2:A8)



Copyright © 2013-2017 Jiri Pik

Document Version: Sunday, May 7, 2017