With almost universal availability of Internet and the availability of reliable on-line productivity tools, such as Google Docs, individuals as well as companies are switching over to Cloud Computing. In this blog I will post items of interest to my colleagues/patrons/clients.
Tuesday, September 11, 2012
yogi_Sort Sheet By Columns Based On Values In A Row
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.