Thursday, June 2, 2011

yogi_Skip Columns With The ImportRange Function

Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                  
Pastor of Muppets said:
How do I skip columns with the ImportRange function
I am using the formula =importrange("abcd123abcd123", "sheet1!A1:G10")
"abcd123abcd123" is the value in the "key=" attribute on the URL of the target spreadsheet and "sheet1!A1:G10" is the range which is desired to be imported.
This works fine but imports data from columns A to G. What if I want to leave out column F, or columns E and F?

view of spreadsheet yogi_Skip Columns With The ImportRange Function - SourceData

I have added Sheet2 for the case where the columns to be Imported are delineated as a comma separated list -- and I have also considered the order in which the data is to be presented for unique columns in the comma separated list.