Hot answers tagged

33 votes

How to reverse the order of selected rows?

Here's an example of how to do this without using scripts - please note that this method assumes your data is just data - it might do strange things if you have formulas referencing other cells in the ...
user avatar
  • 431
15 votes

How can I make some data on a Google Sheets auto-sorting?

Another option without a script is: =QUERY(A1:C3,"SELECT * ORDER BY C") The range is restricted (A1:C3) because where the order is ascending blank entries will appear first.
user avatar
  • 16.6k
13 votes
Accepted

Sort Google Search results by date?

Click 'Search tools' then select any date filter other than 'Any time'. Then click in the default 'Sorted by relevance' option and select 'Sorted by date'
user avatar
  • 357
8 votes

Sort Google Search results by date?

No, you cannot change the sort order of Google Search results. The sort order is determined by Google's secret recipe. All you can do is filter your search for specific time periods.
user avatar
  • 51k
7 votes

How to reverse the order of selected rows?

Following Mir's example you may place SORT function into say cell D3 to reverse order for data in column C: =sort(C3:C,A3:A,False)
user avatar
  • 81
5 votes

How to GROUP and ORDER data in a Google Spreadsheets?

Another way is from within the query: =QUERY(Data!A1:B6;"select A, sum(B), count(B) group by A order by sum(B) desc")
user avatar
  • 16.6k
5 votes

How can I make some data on a Google Sheets auto-sorting?

It can be done using Google App Script. The script will automatically sort whenever there is a change in sheet data. On your Google Sheet: Choose Tools –> Script Editor and paste the below script ...
user avatar
5 votes

How to sort Trello cards by date added

You can use Butler for Trello, which is a bot that automates Trello (I'm the author). This command: sort list "X" by time in list sorts a list by the length of time that a card has been in the list. ...
user avatar
  • 381
5 votes
Accepted

Google Sheets, how to sort query results manually (Not in query)

you can't use Data > Sort sheet by... your sheet needs to be manually sorted by creating a filtered view by selecting your column and then: Data > Filter views... > Create new filter view >...
user avatar
  • 24.5k
4 votes

How can I alphabetize a unique result in Google Spreadsheets?

I add a filter function to keep only cells with data. =sort(filter(unique(A:A);unique(A:A)<>"")) Maybe it could help.
user avatar
4 votes

How can I sort all worksheets in my Google spreadsheet on open?

Try this instead. Code function onOpen() { var sheets = SpreadsheetApp.getActiveSpreadsheet().getSheets(); for(var i = 0, iLen = sheets.length; i < iLen; i++) { var sheet = sheets[i], ...
user avatar
4 votes

Sort Google Search results by date?

Rubén and infrcl have good answers. Here is one way you can sort by date, using Search Query Parameters. Assume you want the last two years sorted by date. Search for your term, hit enter You ...
user avatar
4 votes
Accepted

Dynamically reference data from multiple tabs and sort it

Use curly brackets within this very simple query: =QUERY({Alpha!A2:B;Beta!A2:B;Charlie!A2:B},"select * where Col1 <>'' order by Col2") The trick here is the curly brackets {....} we ...
user avatar
  • 11.7k
3 votes

Prevent Gmail from applying multiple labels

You are trying to turnoff one of the strengths of Gmail. A message can have multiple labels. When Gmail puts the work and contatct1 labels it is doing that because the contactx label is a sub-label ...
user avatar
3 votes
Accepted

Is there a way in Google Sheets to order blank cells first?

I do not think you have any way to control the sort order directly, other than ascending or descending, so suggest a lookup table and a helper column (to determine the sort order) with a formula in ...
user avatar
  • 16.6k
3 votes

Is there a way in Google Sheets to order blank cells first?

One easy way to make the blank cells appear at the top of the sheet when it is sorted is to enter a ' in the cell if it is currently supposed to have nothing in that cell. The ' will not show as text ...
user avatar
3 votes

Sorting a list with points in Google Docs

For want of any better answer so far, I suggest copying your list into a sheet, splitting it on . and on then using the 1,21,3 column to sort the sheet before copying and pasting the revised order ...
user avatar
  • 16.6k
3 votes
Accepted

How to use a query to find a row of same name but last entry, then copy a value next to it

Please use the following (Adjust ranges to your needs) =SORTN(QUERY({INDEX(ROW(D2:D)),D2:E}, "select Col2, Col3 where Col2 is not null ...
user avatar
  • 11.7k
2 votes

Sorting title with numbers in Google Drive

It has been indicated on the Google Product Forum that if you were to put leading 0's as placeholders it will sort properly. So in @Gavin Hudson's example if you created files with names starting: ...
user avatar
2 votes

Is there a way in Google Sheets to order blank cells first?

An alternative regarding blanks sinking to the bottom is to use QUERY, where they float to the top. So starting with: this formula in D1: =query(A1:A3,"Select * order by A") will return a ...
user avatar
  • 16.6k
2 votes
Accepted

Sort auto update

This duplicates data (or since the source for the query is itself imported, even triplicates) but does seem to provide automatic resorting as data input changes: =query(A1:B5,"Select * order by B ...
user avatar
  • 16.6k
2 votes
Accepted

How to sort cells with text and numbers correctly

Key for the sort is the notation of the digits in the text (String #). These are sorted alphanumerically, meaning that 9 is higher than 25 when sorting descendingly. This can be resolved by squeezing ...
user avatar
2 votes

How to sort cells with text and numbers correctly

I suggest a helper column (ColumnC) populated in C2 with: =value(substitute(mid(A2,find(" ",A2)+1,2),"/","")) copied down to suit, then sorted by ColumnC not including header. MID take the ...
user avatar
  • 16.6k
2 votes

Sort Google Search results by date?

Short answer Google Search doesn't include a way to sort unfiltered search results. Alternatives Google Search built-in filters Filter results by any time filter. This will display several dropdowns. ...
user avatar
  • 41.6k
2 votes

Sort Google Search results by date?

To add to https://webapps.stackexchange.com/a/89543 above, there is a hacky way to sort all Google search results from "Any time" by date so you get new results at top without using any time range. ...
user avatar
  • 121
2 votes
Accepted

How to sort names in column alphabetically ignoring "The", "An" & "A"... and then pull names (skipping duplicates) into another tab

Database Software I think Google Sheets can do this but do consider whether to use proper database software (Google for "database software"). Those will handle tables of data with more/easier high-...
user avatar
  • 2,370

Only top scored, non community-wiki answers of a minimum length are eligible