Wednesday, October 5, 2011

yogi_Sort Data In Another Sheet By Specified Column In Specified Order

Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                  
a user asked:
How do I sort sheet 1 column BI'm new to Google docs and have used excel for most everything. This simple sort on excel by pop up box (sort by COLUMN B, sort on VALUES, order LARGEST TO SMALLEST) I can not figure out on Google docs. Column A is names and must stay with the associated data in column B. Column B is scores being populated by sheet 2. The scores change weekly by the data entered on sheet 2. A manual sort is fine, but if it could be an auto sort that would be even better.-----------------------------------------------------

Data is in Sheet1 ... and using the SORT function, I have sorted it in Sheet2