Yogi Anand, D.Eng, P.E. Google Spreadsheet www.energyefficientbuild.com
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.
No comments:
Post a Comment