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.

 

Examples:

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