New answers tagged sorting
0
votes
Sorting unique rows by a related SUMIF column
Summary Table
You are generating the summary table using multiple formulas but the entire table including headings and sort options can be generated using a single QUERY formula in A1.
Single QUERY ...
0
votes
Sorting unique rows by a related SUMIF column
I'm running into exactly the same thing, and I also did a workaround but I didn't make another sheet or use the QUERY() function.
I put the contents of my UNIQUE() function into a separate column, and ...
1
vote
Google Sheets, how to sort query results manually (Not in query)
Keep your primary sheet as a main "level 1" sorting logic and
querying sheet.
Use ORDER BY in your first sheet.
Hide your first sheet.
Then pull your data to a second sheet with a simple ...
Top 50 recent answers are included
Related Tags
sorting × 141google-sheets × 99
formulas × 26
google-sheets-query × 20
google-apps-script × 19
google-sheets-arrayformula × 10
gmail × 8
vlookup × 4
youtube × 3
trello × 3
google-sheets-dates × 3
regex × 3
google-drive × 2
google-search × 2
google-forms × 2
gmail-labels × 2
office-365 × 2
youtube-playlist × 2
filter × 2
google-sheets-filter × 2
pivot-table × 2
excel-online × 2
google-docs × 1
twitter × 1
google-plus × 1