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.
Thanks
Eric
----------------------------------------------------------------------------------------------

following is a solution to the problem

2 comments:

  1. Hi Yogi,

    Thank you for getting back to me. I used the formula however it is not working. It says circular dependency detected.

    Here is a link to a copy of the document that I am using for testing:
    https://docs.google.com/spreadsheet/ccc?key=0At0Jsoal09opdEhkd2E1NGpoNEV5VEQ3SzBYeEg0MXc
    That has the formula in cell A2. It also should allow you to edit it.

    Thanks

    ReplyDelete
  2. Hi Stewie:

    You are getting circular dependency error because chances are you have used the formula in cell A2 of sheet Final. You have to use the formula in a new sheet such as yogi_Final as I have used in my solution.

    Cheers!
    Yogi
    Cloud Computing -- Google Docs Way
    yogi--anand-consulting.blogspot.com

    ReplyDelete