Monday, September 3, 2012

yogi_Add To August Column Numbers From September Column And Sort In Descending Order

Yogi Anand, D.Eng, P.E.       Google Spreadsheet    Post  #727   Sep 03, 2012     www.energyefficientbuild.com.

user DanielL said: (http://productforums.google.com/forum/?zx=nclx24r3fxl3#!search/DanielL/docs/dXPusr92Avs/Bm36uR2PV7AJ
how to add 2 columns data to SORT() without script and without extra columns 
I'm currently using the function on the result(G2), if there won't be a performance problem with very large lists I can just keep it like that.

------------------------------------------------------------------------------------
typically, a formula based solution would execute faster than a script based solution ... so following is a formula based solution