When I'm working in a Google Spreadsheet, I always use the same routine to perform a sort.
Are there more ways to sort, that lead to Rome?
There are four ways for you to perform a sort. See list below in no particular order:
Add the build-in filter function, by pressing the funnel and selecting the first row:
Use this formula, on another sheet, to perform the sort you want:
Syntax of the sort is:
With the usage of a script, complex sorting is possible as well. This one creates a menu item called
Goto Tools, Script Editor, from the menu and add the script. Make sure to press the two buttons:
Select column A and choose Data from the menu. Select "Sort sheet by Column A, Z --> A"
Make sure to fix the first row (otherwise the header will join the sort....) !!
I've prepared the following example file: Four Different Sorts