New answers tagged

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 ...
Blind Spots's user avatar
  • 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 ...
bweisberger's user avatar
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 ...
Demir Aydemir's user avatar

Top 50 recent answers are included