Yogi Anand, D.Eng, P.E. Google Spreadsheet Post #782 Sep 28, 2012 www.energyefficientbuild.com.
user GiveDark said: (http://productforums.google.com/forum/?zx=d088tq41gvii#!category-topic/docs/spreadsheets/5-A4_I3thYI
Script to sort certain columns in spreadsheet
I want to write a script that will sort part of a spreadsheet by one column, but keep the rest of the spreadsheet unsorted. The column that I am sorting by (say column B) is always the same. I a couple other columns to follow the sorting of column B (so that the rows stay together). So far this is the equivalent of -> Data -> Sort Sheet by Column B. However, I do not want the rest of the columns to be sorted. They should stay exactly the same.
Does anyone have any hints on how to write a script for this? Even tips on doing part of this would be helpful, such as how to select only certain columns.
Thanks
-----------------------------------------------------------------------------------------------
see the following illustration
user GiveDark said: (http://productforums.google.com/forum/?zx=d088tq41gvii#!category-topic/docs/spreadsheets/5-A4_I3thYI
Script to sort certain columns in spreadsheet
I want to write a script that will sort part of a spreadsheet by one column, but keep the rest of the spreadsheet unsorted. The column that I am sorting by (say column B) is always the same. I a couple other columns to follow the sorting of column B (so that the rows stay together). So far this is the equivalent of -> Data -> Sort Sheet by Column B. However, I do not want the rest of the columns to be sorted. They should stay exactly the same.
Does anyone have any hints on how to write a script for this? Even tips on doing part of this would be helpful, such as how to select only certain columns.
Thanks
-----------------------------------------------------------------------------------------------
see the following illustration
No comments:
Post a Comment