Skip to main content

Questions tagged [sorting]

Sorting is the process of applying some order to a collection of items.

Filter by
Sorted by
Tagged with
96 votes
10 answers
363k views

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

Let's say I want Google Sheets to automagically sort some data, for example column C. How do I do that? I know that I can manually sort data by right-clicking and selecting Sort data, but this is ...
user avatar
50 votes
3 answers
88k views

How to reverse the order of selected rows?

Is there an easy way to reverse the order of selected rows? (Or how about all rows, if that's easier.) Specifically, in this case, there is no column that could be used for sorting to get them in ...
Jonik's user avatar
  • 3,798
18 votes
2 answers
3k views

Is it possible to sort your email in Gmail by something other than the date received?

I want to sort my email in Gmail by the sender, rather than the date received, is there a way to do this?
LBushkin's user avatar
  • 1,486
14 votes
3 answers
38k views

How can I alphabetize a unique result in Google Spreadsheets?

I'm generating a list based on using the UNIQUE function. How can I get the output to be alphabetized automatically?
Rebecca Dessonville's user avatar
12 votes
6 answers
15k views

Sort Google Search results by date?

Is there a way to sort Google Search results by date? (I know how to limit the search to a particular time period.)
aparente001's user avatar
  • 1,074
7 votes
2 answers
240 views

Sort Gmail messages by how long people have been waiting for a reply

I am trying to help someone break the habit of delaying too long in replying to emails. For a select group of email senders in Gmail, I'd like to set up some way of seeing how long it has been since ...
Ramon's user avatar
  • 101
7 votes
2 answers
5k views

How to sort posts on Reddit by number of comments?

How to sort posts on Reddit by number of comments? I'd find this more useful than sorting by votes.
Colonel Panic's user avatar
7 votes
1 answer
2k views

Sort Gmail *search results* oldest first [duplicate]

Mail can be sorted oldest to newest in Gmail by clicking on the email count and choosing Oldest. However, for search results, the sort order selections seem to be disabled: Is it possible to sort ...
Jason C's user avatar
  • 367
6 votes
2 answers
4k views

Prevent Gmail from applying multiple labels

I have recently imported all my mail from Outlook.com and my work email into the gmail accout and I have started to organize the messages using labels. The filters work great and I have managed to ...
lucian's user avatar
  • 161
5 votes
1 answer
22k views

Can I protect rows in a Google Docs spreadsheet from sorting?

I can sort a Google Docs spreadsheet on any column, but that sorts ALL of the rows. I don't want to sort the rows that contain the column labels. Is there a way to protect them from being sorted? I ...
Phil Goetz's user avatar
5 votes
3 answers
7k views

Sorting Google spreadsheet by month and day but not year

I made a Google spreadsheet with a list of birth dates, anniversaries, etc. that I would like to sort by when they occur in the year, not when they first happened. If you sort by the date normally, it ...
techturtle's user avatar
  • 1,040
5 votes
2 answers
3k views

How to sort Trello cards by date added

Trello is rad. But one thing I haven't figured out: How to sort cards in a list by the date that the cards were added to the list (or to the board)? Also, is it possible to show (as a custom field?) ...
samthebrand's user avatar
  • 5,469
5 votes
1 answer
2k views

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

I have successfully been able to sort the first sheet in my Google Spreadsheet onOpen, but I'd like to sort all four spreadsheets onOpen and I can't make this work. I've tried quite a few variations ...
Sarah's user avatar
  • 51
5 votes
1 answer
8k views

How to sort groups of rows in Google Sheets?

I have a spreadsheet with lots of related rows. How can I sort the entire sheet in such a way that rows that belong together stay together in groups, and the groups instead are sorted by some common ...
Zom-B's user avatar
  • 391
5 votes
1 answer
17k views

How do I read a users Tweets starting with the oldest?

I've just started to follow 'RealTimeWWII' but I'd like to read his Tweets to date starting with the first (he has ~850 so far so I think they should still be all there) I keep clicking 'More' but ...
Brendan's user avatar
  • 51
5 votes
1 answer
1k views

How to organize Youtube play lists in Alphabetical order under the Save button?

I've created many YouTube playlists and it's getting harder and harder to find the right playlist when I click on save as they are not sorted alphabetically. Is there a way to sort the playlists ...
PinkSamurai Fairlady's user avatar
5 votes
3 answers
10k views

Sorting title with numbers in Google Drive

When I sort by title in Google Drive, I would like it to numerically go 1 → 2 → 3 … etc., but instead it goes 1 → 10 → 100 → 1000 → 1001 → 1002 … etc. Is there any way to get it to do the first ...
Devi's user avatar
  • 51
4 votes
3 answers
12k views

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

When I sort a column in Google Spreadsheets, the blanks always seem to sink to the bottom. Can I have rows with blank cels be organized first / highest? Alternatively, is there a function wherein I ...
New Alexandria's user avatar
4 votes
3 answers
4k views

Sorting unique rows by a related SUMIF column

I am putting together a worksheet to keep track of expenses. I currently have the following source table called "Expenses": A         B C D 1 Date Description Category Amount 2 1-Jan ...
jared's user avatar
  • 41
4 votes
3 answers
5k views

Sorting Gmail contacts by date

Is it possible to sort Gmail contacts by date? I want to see the last contacts added and couldn't find a way to do this. The only option I see is by first and last name.
Gabriel Solomon's user avatar
4 votes
3 answers
8k views

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

My google sheet is importing data from another tab just for sorting purpose, however, when the sort is done manually (through Google Sheet menus), results are unpredictable. The sheet is populated ...
Riccardo's user avatar
  • 589
4 votes
1 answer
2k views

Dynamically reference data from multiple tabs and sort it

I've got a spreadsheet with multiple tabs of data. The data contains 2 columns, A = Categories, B = Quantity. I've created a copy of the spreadsheet HERE (please use file > copy) if you would like ...
sam's user avatar
  • 6,989
4 votes
1 answer
21k views

Sort Gmail by Date? [duplicate]

Possible Duplicate: Is it possible to sort your email in GMail by something other than the date received? Is there any way to sort Gmail by date in the web interface? The priority inbox is nice, ...
cwd's user avatar
  • 814
4 votes
1 answer
159 views

Sorting a list with points in Google Docs

In Google Docs, how would I go about sorting a list of chapter numbers (for example) with points in between, e.g. 1.1, 1.21, 1.3 in the right way so that 1.21 follows 1.3?
V811's user avatar
  • 41
4 votes
1 answer
3k views

Sorting a protected range in Google spreadsheets

I've been trying to make the spreadsheet automatically sort some data, and after some searching I found this post: Automatic sorting. It works just perfect with my permissions as the owner, but when ...
Mohamed Osama's user avatar
4 votes
0 answers
362 views

How to make "Highest Rated" the default on yelp.com

Whenever I start a new search on Yelp, it sets the sort order to "Best Match." Is there a way to have the default be "Highest Rated" instead? If I can't figure anything else out, I'll set up a ...
Michael Hoffman's user avatar
3 votes
2 answers
32k views

How to GROUP and ORDER data in a Google Spreadsheets?

I want to group and sort a particular data set. I've prepared the data using a QUERY function and using other functions. Can I order by sum? This is an example file I created: order by sum
Lucas Ribeiro Maia's user avatar
3 votes
1 answer
9k views

Sorting alphabetically (A-Z) ignoring beginning "A", "An" and "The" using a script

I have a Movie list using Google Sheets that I would like do some sorting with using a script rather than a formula. Column A is the movie Title. I would like to be able to sort the movie titles ...
Computer Candy's user avatar
3 votes
2 answers
10k views

How to sort cells with text and numbers correctly

This is my example list: example file As you can see I am sorting all unique elements in row B. But the "Sprint 9" gets sorted as the highest value, not the lowest. I really have no clue how I can ...
Daniel's user avatar
  • 33
3 votes
1 answer
448 views

How can you change the sort order in reader view?

I'm one of the many people jumping early from Google Reader in wake of the announcement to look for replacements. I'm quite happy with Netvibes' reader view, which is almost exactly what I had with ...
DoraTrix's user avatar
3 votes
1 answer
3k views

Sort my Trello cards and lists alphabetically

I have an "Active Projects" board on Trello that has about 60 lists in it, each with about 1-4 cards. I want to sort the 60 lists I have alphabetically rather that assigning them a number placement.
user29038's user avatar
3 votes
1 answer
43 views

Can I sort cells in Google Sheets with a key function?

I have some data in a Google Sheets document that I would like to sort by computing some value from two columns and using that as the sort key. Say my data is like this: A B C D 1 ... ... 8700 5 2 ....
JM0's user avatar
  • 131
3 votes
1 answer
1k views

How to sort by date with Google Spreadsheet?

Consider the following text in a single column in a spreadsheet: AAPL 2015 Dec 18 C @ 185.000 AAPL 2016 Mar 18 C @ 160.000 ... How to sort by date? I tried extracting the date using regex, but it ...
B Seven's user avatar
  • 517
3 votes
3 answers
12k views

Auto sort of Forms responses so that the most recent one is on top

We use Google Forms to collect guest surveys for our resort. New responses get added to the bottom of the response sheet. While we can manually sort the responses using the time-stamp feature, not ...
user67910's user avatar
3 votes
1 answer
166 views

Sort the pictures of an album by date on geni.com

How do I go about sorting the pictures of an alum in Geni.com by date? Basically you can sort pictures "manually" dragging them around but as I already took my time to put the correct date on every ...
Omar Kohl's user avatar
  • 443
3 votes
1 answer
6k views

Auto Sort Google Sheet with onEdit function

The following function successfully sorts my file (containing 3 sheets) individually. When I hit the "play" button on the script, it properly sorts (as expected) the current (active) sheet. Since my ...
Joel's user avatar
  • 31
3 votes
1 answer
2k views

Auto sort data but by sheet not range

I found this script from How can I apply a script to only one specific sheet within a spreadsheet to auto sort a column: function onEdit(){ var sh0 = SpreadsheetApp.getActiveSpreadsheet()....
moobot's user avatar
  • 141
3 votes
1 answer
550 views

How to sort Google Sheets columns by row height

I'm working on a sheet that involves multiple columns corresponding to various data. Each column has a varying number of cells of varying heights with wrapped text. What I want to do is make the sheet ...
nagolitica's user avatar
3 votes
2 answers
231 views

Altering the Sort Filter in Google Spreadsheets

I live in Australia and when I'm putting in dates, I place the date, followed by month then the year. However when I am filtering/sorting my spreadsheet it's coming up incorrectly. How do I edit ...
Kara's user avatar
  • 31
3 votes
1 answer
122 views

A simple spreadsheet sorting

In a Google Spreadsheet I have different groups of cells in one column to auto-sort. All cells in this column have same pattern of data, all datum have it's own cell and it's needed to be sorted into ...
user46797's user avatar
3 votes
1 answer
3k views

Sorting on a web-published Google Spreadsheet

I have a Google Spreadsheet that is published to the web and embedded in a website. This spreadsheet has data about hotel rooms, such as hotel name, number of rooms, date in and out, etc. I would ...
Palmer Del Campo's user avatar
3 votes
0 answers
623 views

How to sort Youtube subscriptions by updates?

When I enter YT on the left pane I have "Subscriptions" section sorted by the date of the subscription. So as the effect I could have: Subscriptions A D 1 E F G 7 --- show more --- B 3 ...
greenoldman's user avatar
3 votes
0 answers
818 views

How to display and sort all Google+ posts based on most voted video/photo?

I would like to display all Google+ posts into my website and I would like to categorise them into: most voted video/photo most recent video/photo How can I achieve the above? I know how to embed ...
sree's user avatar
  • 179
3 votes
1 answer
2k views

Simultaneously sort multiple ranges on a single sheet in varying orders

I am trying to find a way using a script if possible (or formula) that will allow me to reduce the number of operations that I have perform to sort data in a particular google spreadsheet. Currently, ...
Max's user avatar
  • 31
3 votes
0 answers
177 views

Sort Delicious bookmarks from all users by popularity

When on the Delicious homepage there is the hotlist > popular bookmarks. This only shows very few bookmarks. Doesn't seem to be actually tagged bookmarks ranked by number of times saved by different ...
Hauser's user avatar
  • 219
2 votes
1 answer
184 views

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

I am trying to use a query to copy values from one column to another. Both source and destination columns have a name on their left columns, and the name must match. The source names could be ...
sofname's user avatar
  • 137
2 votes
3 answers
3k views

Missing sort in Google Spreadsheets menus

I have a Google spreadsheet that has the A column as an ID field (incrementing numbers 1...1000; no formula, just numbers). That column is frozen as is the first row of headers. I sorted by column B ...
Chris Burgess's user avatar
2 votes
2 answers
2k views

View IMDb top lists sorted by demographics to give more personalized ratings

How do I view the IMDb top lists sorted by demographics in order to get more personalized ratings? For example, I would find it more useful if I could view the Top 250 films list, while counting ...
tobeannounced's user avatar
2 votes
1 answer
150 views

How is alphabetization determined in Excel and Google Sheets?

I was recently sorting data in Google Sheets that involved the word "hello" in various languages. An excerpt of this sheet is below. Column C was calculated using the =UNICODE(LEFT(B2,1)) ...
Brooke's user avatar
  • 133
2 votes
1 answer
3k views

How to sort by descending date within a conversation in MS Outlook 365

I am using MS Outlook and I would like to sort emails based on conversation and then descending by date within each conversation so that the most recent email is at the TOP vs bottom. I tried Arrange ...
Chris's user avatar
  • 121