Showing posts with label user:DanielL. Show all posts
Showing posts with label user:DanielL. Show all posts

Monday, September 3, 2012

yogi_Consolidate Names And Numbers From August And September Columns And Sort In Descending Order By Numbers

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

This is an extension to the solution I had posted in response to a question from user DanielL in my following blog post:
yogi_Add To August Column Numbers From September Column And Sort In Descending Order, 
http://yogi--anand-consulting.blogspot.com/2012/09/yogiadd-to-august-column-numbers-from.html

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