New answers tagged sorting
0
votes
How to order column groups by a cell's value
Try somethig like this:
={SORT(A1:A,1,true),SORT(B1:B,1,true),SORT(C1:C,1,true),SORT(D1:D,1,true),SORT(E1:E,1,true),SORT(F1:F,1,true)}
In this way you can sort the columns independently of each other,...
0
votes
Google Spreadsheets-Autosort but with a second argument
Create the sorted results using a query. This query is located in the same sheet as the raw data, but the query can be created on any sheets (such as the Results Sheet).
Locations using decimal points
...
0
votes
Google Spreadsheets-Autosort but with a second argument
is this what the formula you're trying to use:
=sort(A3:C8,2,false,3,false,1,true)
BEFORE/AFTER
SORT Documentation
Top 50 recent answers are included
Related Tags
sorting × 133google-sheets × 92
formulas × 25
google-sheets-query × 21
google-apps-script × 19
google-sheets-arrayformula × 10
gmail × 7
youtube × 4
vlookup × 4
trello × 3
regex × 3
youtube-playlist × 3
google-drive × 2
google-search × 2
office-365 × 2
filter × 2
date × 2
google-docs × 1
twitter × 1
google-forms × 1
google-plus × 1
google-chrome × 1
search × 1
outlook.com × 1
gmail-labels × 1