Episode #125 of the Stack Overflow podcast is here. We talk Tilde Club and mechanical keyboards. Listen now

Questions tagged [sorting]

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

Filter by
Sorted by
Tagged with
1
vote
0answers
6 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 ...
2
votes
2answers
1k 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 ...
0
votes
0answers
27 views

How to get MediaWiki random order lists sorted?

When making a bulleted list in MediWiki, maybe over time, the order is usually random unless manually organised. * [[Citrus reticulata|mandarin]] * [[Malus sylvestris|crabapple]] * [[Prunus domestica|...
0
votes
2answers
12 views

Auto Sort different ranges

I have a google sheet that I would like to sort different ranges by the 2nd column in each range. Example: A B C D E F G p 7 1 h 9 1 q 6 2 j 3 2 g 9 3 p 7 3 I need the range A:C sorted by B ...
-1
votes
1answer
13 views

Sorting column A with drop-down and column B with checkbox

I have a spreadsheet that I use to run a foosball tournament, and in column A I have a dropdown data validation that will let me select a players name. In Column B I have a checkbox that I check once ...
2
votes
1answer
44 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 ...
4
votes
1answer
2k 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 ...
-1
votes
3answers
14 views

How do I sort data by size and not in ABC order

I am new to Google Sheets and have only used Excel a little, so Google Sheets is a bit different. I want to sort our band uniforms in size order from smallest to largest but Google Sheets only sorts ...
0
votes
1answer
35 views

Auto sorting / copying data based on inputted data?

Sorry if this is a bit confusing or if I’m not explaining this well enough. Using my provided picture as an example how would one auto copy data that gets inputted into that table based on estimated ...
0
votes
1answer
10 views

Using UNIQUE and SORT together

I'm currently using UNIQUE to look through a spreadsheet and display in another spreadsheet all the unique names in a certain "Name" column. However, I need to sort these names by another column ...
0
votes
1answer
246 views

Is it possible to make a custom sort on column other than A-Z or Z-A in Google Sheets?

The Sheet has a column with cells populated by a dropdown list offering 3 choices: Good; Very Good; Rejected; In that context, it would be practical to sort the column according to a specific/custom ...
1
vote
1answer
56 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?
3
votes
1answer
730 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, ...
3
votes
1answer
986 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 ...
1
vote
1answer
239 views

Filter View: Sort by custom string order

Say I have a spreadsheet containing names, dates and a rank. The spreadsheet is by default sorted by date but I want to create a filter view that sorts the spreadsheet by the rank column, i.e., "...
10
votes
3answers
17k 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?
57
votes
6answers
181k 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 ...
0
votes
1answer
20 views

Sort sentences based on formatting

I have a list of sentences in Google Sheets, each word in a different column. There is a stupid man. How we came here we don't know anything about. Finally, it has come to this. Shaking my head. How ...
0
votes
3answers
86 views

Trying to run two scripts on same sheet and getting error

I found a code to run the two different scripts online, however i keep getting an error Missing ; before statement. Original function onEdit(e) { oneditfx1(e); oneditfx2(); } function ...
1
vote
1answer
24 views

How to extract the first rows that have a unique value in specific column in Google Sheets?

The unique items in D are: 4,3,2. I wish to extract 3 rows for each D value, For each row, provide the first row that this D value appears. I tried using =query but it doesn't support grouping or ...
0
votes
2answers
448 views

Cannot Find Function 'getRange' in Google Script

I'm working on setting up a series of scripts for a google sheet where I want to be able to auto sort based off of when something gets entered into the third column, sorting first by the first column (...
0
votes
1answer
16 views

Having a formula output to a different cell

I have a Google Sheet in the following format: ID | VAL ------------- 1 | dataH 2 | dataW 3 | dataX 4 | dataC 5 | dataG 6 | dataL ... | ... ID and VAL are on cells A1 and B1, ...
1
vote
1answer
20 views

Solve errors in a series of FILTER functions within array brackets?

I have been working on a budget project on Google Sheets. My goal is for a range of data to be filtered by date (which is represented as an integer between 1 and 31 for the day of the month). All ...
1
vote
2answers
66 views

Sorting columns with script instead of macro

I currently use a macro script to filter my sheet upon opening the sheet by column A, and I wondered if there was a more efficient/simple way to do it with scripts? function Sort() { var ...
0
votes
1answer
16 views

Merging data sets from two tables with origin reference [duplicate]

In a Google Sheet, I have multiple tables containing a list of dates. I want to create a single (sorted) list containing all the dates and the table they came from. Table foo: 1.1.19 3.1.19 Table ...
0
votes
1answer
12 views

Locking information in rows together

I have a Google sheet with contact information that is accessed by many people. These people need to have the ability to sort information and edit it. Some users, when sorting, accidentally only ...
1
vote
1answer
13 views

How do I make one filter take into consideration the order of other columns?

I'm using the Filter (the one you create with the button in 'menus') to sort my table, but when I click the filter icon in a column's header and select "Sort A→Z", it only applies to that column. ...
1
vote
1answer
47 views

Sort Google Spreadsheets so it returns 'alternating' values in a column

How can I sort a random list in Google Sheets so it returns alternating values? The current random list looks like this: fName lName Room ID ----------------------------------- Sara Don ...
1
vote
2answers
401 views

Sort a Google Spreadsheets so it returns 'alternating' values in a column

I have a list of hundreds of students that contains the following data. The only two values that will appear in the gender column (col 3) are male or female: Current List fName | lName | ...
1
vote
1answer
30 views

Sort by a Column While Maintaining Information in a Row

I had a previous question with lots of support and it solved my problem. The next issue I have is sorting the data while bringing the information in the corresponding row with it. A link to the ...
0
votes
3answers
632 views

How Can I Sort a Data Range in Google Sheets Based on an Data Range?

I have been looking for a way to sort this information. I need to sort these items in this order: BK, BB, BV, BIV, BIII, BII, BR. I was trying to make a Google Script to get it, but I could only ...
1
vote
1answer
54 views

Combing two ranges with identical column structure from two different sheets (in same spreadsheet)

I'm doing a simple ticketing system, where I have two sheets, "Form Responses" and "Email Responses" both of which are populated automatically as their names imply (one from a form, one from an email ...
0
votes
1answer
920 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 ...
0
votes
0answers
220 views

How to auto-sort from a drop down box?

Without having to manually auto sort alphabetically, how can I get it to automatically sort when creating a new project and choosing A,B,or C, from the drop down menu in the the first column. See ...
1
vote
0answers
33 views

How do I sort Glassdoor reviews by rating on a computer?

The Glassdoor mobile app in both iOS and Android has an option to sort and filter reviews. As far as I know this does not exist on the computer version of the Web App. How do I sort Glassdoor ...
2
votes
3answers
8k 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 ...
3
votes
0answers
421 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 ...
2
votes
2answers
4k 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 ...
0
votes
0answers
787 views

Sorting a sheet without losing group order

I've got a large sheet (tens of thousands rows) grouped into hundreds of different groups. All the groups are collapsed so I only see the top-level cell of each group. Now I want to sort on a these ...
0
votes
1answer
118 views

I need help with sorting query in Google Sheets

I have a zap that pulls "Email" data from a spreadsheet, I also have a query that pulls "NAME" data from a different spreadsheet, but when I try to sort it, the data gets misplaced, eg. blank rows ...
1
vote
2answers
10k 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
0
votes
2answers
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 ...
0
votes
1answer
41 views

spreadsheet conditional: if in top x then

spreadsheet data: Total Average Highest Top Sales $23,550.00 $7,850.00 $8,100.00 not $42,700.00 $14,233.33 $14,400.00 not $30,500.00 $10,166.67 $10,300.00 not $37,840.00 $12,613....
2
votes
1answer
2k 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
0answers
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 ...
0
votes
1answer
3k views

Can I sort rows in Google Sheets by date?

In Google sheets I'm trying to sort rows according to a date column. According to my experience I can use column filtering and choose to sort data from A-Z. However this will give a wrong result for ...
4
votes
3answers
5k 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, ...
7
votes
2answers
198 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 ...
0
votes
1answer
38 views

Is it possible to sort topics in Rizzoma by number of votes?

Overview As Google Moderator is shutting down on June 30, 2015 (more Info) I would like to learn about alternatives, mainly for educators. Rizzoma topics could include the Yes/No/Maybe Wave gadget, ...
3
votes
1answer
412 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 ...