Hot answers tagged

32

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 same range: Insert a new column (for the sake of example, we'll call it column A). In A1, put the value [1]. (You can start at A10, or A50 if you only want ...


14

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.


13

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'


8

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.


6

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)


5

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 and save. Replace the SHEET_NAME, SORT_DATA_RANGE and SORT_ORDER variables with corresponding values. SHEET_NAME = "Sheet1"; SORT_DATA_RANGE = "A1:C999"; ...


5

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")


5

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. You can also reverse it: sort list "X" by time in list descending You can apply the command at certain times, e.g.: every day at 6am, sort list "X" by time ...


5

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 > Sort A - Z a downside is that it's a view so it won't stay like that after closing your spreadsheet. also, note that formula needs to be outside or inside of ...


4

This would be a great feature for me too, but AFAIK it doesn't exist. My solution to cope with such a problem is to use the service called Boomerang. What I do is that I empty my inbox as much as possible multiple times a day (at least once). For any email that would take me longer than 5 minutes to write a response to, I delay it: I ask for it to be "...


4

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


4

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], range = sheet.getDataRange(); range.sort({column: 1, ascending: true}); } } If you want to sort from a certain row or column, then use this code function ...


4

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 will get a URL, which includes Search Query Params. Copy it. Append &tbs=qdr:y2,sbd:1 to your URL and hit Enter. Now you will have "Past 2 years" and "...


3

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 of the work label. Multiple labels make it easier to find messages/conversations because you can use the presence or absence of labels to filter the results of ...


3

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 in the cell, therefore appearing to be a blank cell. When you sort in ascending or descending order, it will put the blank cell either at the top or at the ...


3

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 that such as: =if(B1="",1,vlookup(left(B1,1),E:F,2,0)) where ColumnB is the one to be sorted, ColumnE the sort order and ColumnF a number starting at 1 and ...


3

It is not possible to change order of sorting, according to Netvibes Documentation page: http://documentation.netvibes.com/doku.php?id=main#reader_view In Reader View, the screen is divided in three main parts: A: list of your tabs and feeds B: selection and display options of the content C: all the currently selected feed items D:...


3

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 back into your document - manually rearrangement may be easier!


3

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 use to create and combine the arrays from the different tabs. Extra tip: {Alpha!A2:B;Beta!A2:B;Charlie!A2:B} A semicolon ; combines vertically (in columns, one ...


3

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 order by Col2, Col1 desc"), 9^9,2,1,1) How the formula works We add a virtual column based on each row to our query and order the query. We then -in ...


2

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: 01, 02, 03, 04, 05, 06, 07, 08, 09, 10, 11 It would sort properly. In the general case, you need to find out the order of magnitude of how many files you have ...


2

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 desc")


2

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 blank in D1, i in D2 and x in D3.


2

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 in a zero to all digits ranging from 1 to 9. See formula I constructed. Formula =SORT( // range UNIQUE( // range ...


2

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 first and second characters after the first space (located with FIND) and since one of those might be /, SUBSTITUTE replaces any / with nothing. VALUE then ...


2

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. One of them if for sorting options including sorting by date. (see [4]) Google Custom Search One alternative could be to create your own search engine with ...


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