Tuesday, September 11, 2012

yogi_Sort Sheet By Columns Based On Values In A Row

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

user Estauss said: (http://productforums.google.com/forum/?zx=4yq9wcrgo0dm#!category-topic/docs/spreadsheets/_1CJJFTzwEo)
How to sort sheet based on values in a row

I am running an office pool for Football picks. Last Year I used Excel, this year I decided to use Google Docs so that I can share the sheet over the internet.
Here is the link to the document:
Each person picks the winner for the entire season. So I have 17 sheets, one for each week where I input their picks for that week. The final sheet has the results for each week and the season as a whole.
What I want to do is sort the sheet based on the value in Row 20. Who ever has the most picks correct their column would appear first, and so on down the line. In excel I would simply select the columns and choose sort by ROW sort on VALUES order LARGEST to SMALLEST. I can't seem to find a way to do this with Google.
Any help would be greatly appreciated.
I am using Win7 as my OS and Chrome as my browser.

following is a solution to the problem