Questions tagged [sorting]
Sorting is the process of applying some order to a collection of items.
138
questions
1
vote
1
answer
117
views
Google spreadsheet, sort adds a bunch of rows
I have a function that sorts a table, unfortunately when I call my function it adds a bunch of empty rows at the bottom that I don't like.
var kotlijst = SpreadsheetApp.getActiveSpreadsheet()
....
- 11
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, ...
- 31
7
votes
2
answers
221
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 ...
- 101
5
votes
3
answers
9k
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 ...
- 51
4
votes
1
answer
146
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?
- 41
3
votes
0
answers
345
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 ...
- 286
3
votes
1
answer
120
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 ...
- 39
3
votes
2
answers
29k
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
2
votes
1
answer
555
views
How Many Ways To Sort in Google Spreadsheets
When I'm working in a Google Spreadsheet, I always use the same routine to perform a sort.
Are there more ways to sort, that lead to Rome?
- 22.5k
48
votes
3
answers
83k
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 ...
- 3,728
1
vote
1
answer
88
views
How can I preserve sort order?
Is it possible to get Google Music to preserve my selected sort order? I'm getting tired of clicking the "Artist" column header to sort by artist name every single time I switch views.
- 251
2
votes
1
answer
1k
views
How to use Google Scripts w/ spreadsheet and jotform to auto sort so the newest entry is always listed on the top row?
I'm trying to setup a form and spreadsheet database to track inventory on a daily basis at a remote location. The idea is that the person at the remote location can update our stock via a simple ...
- 29
2
votes
1
answer
591
views
Google spreadsheet multiple auto-sorting
In a Google Spreadsheet I have different group of cells to auto-sort ascending i.e.
table range a3:c16 columntosortby = 2
table range d18:f31
columntosortby = 5
table range g33:i46 columntosortby = 8
...
- 31
2
votes
2
answers
224
views
Auto sort a sheet so that entries remain in their categories
So I want to sort my Spreadsheet on Google but it remain in the Categories that it's laid out. I can get to it sort double columns but the categories get messed up as they move away from where they ...
0
votes
1
answer
18k
views
Show new mails at the top in outlook.com inbox
While trying to read inbox, I expect to view new emails from top down order. While it works in every other mail box, in outlook.com, my Hotmail doesn't show in that manner, if I have create new mail ...
- 9
3
votes
1
answer
426
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 ...
- 31
6
votes
1
answer
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.
- 817
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 ...
- 1,040
2
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 ...
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 ...
2
votes
1
answer
1k
views
In Google Docs, how to make a column with several numbers in each cell sortable?
I am making an expenses spreadsheet in Google Docs and I need to list the numbers of the attachments for each entry. Sometimes this is just one number, sometimes it is several.
I can make this ...
- 183
2
votes
1
answer
114
views
Is there a function I can enable to have a Check List action item populate in multiple boards I select?
I have an "Active Projects" board that has about 60 lists each representing a company I manage. Each company has 1-5 cards representing projects we are working on. Each card has a "TO DO" checklist.
...
- 51
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.
- 51
14
votes
3
answers
34k
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?
- 8,026
4
votes
1
answer
3k
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 ...
- 41
-4
votes
1
answer
2k
views
Simple row references in Google Spreadsheets and resorting data
This is my scenario
Users are entering data into rows with several columns
Last column is calculated on values of few previous columns (so it's row number independent).
While entering new and ...
- 2,195
0
votes
1
answer
1k
views
YouTube Playlist Annoyances (Sorting, etc)
If I am viewing a video, and I wish to add it to a playlist of mine, I click on the Add to Playlist button. (I bet you're going, "No, duh.")
The problem with this is:
I have 18 playlists and ...
- 125
5
votes
1
answer
16k
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 ...
- 51
2
votes
3
answers
2k
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 ...
- 161
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, ...
- 784
4
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 ...
- 229
0
votes
2
answers
1k
views
How do we actually do list sorting in Google Bookmarks (alphabetical order)
I use Google Bookmarks and I’d need a way to sort all my lists in alphabetical order.
The "My lists" current has itself sorted in last modified order... and although that’s useful, it is more useful ...
- 5,923
1
vote
1
answer
66
views
Sort all my j.mp links by most clicked
Is there any way I can get all of the links associated with my j.mp account and arrange them so that the links with the most clicks are at the top?
- 21
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.
- 234
91
votes
10
answers
335k
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 ...
Diego Petrucci
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 ...
- 2,783
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 ...
- 443
15
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?
- 1,446