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 ...
- 2,974
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