Questions tagged [sorting]

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

Filter by
Sorted by
Tagged with
0
votes
0answers
1 view

Using a cell to build a formula

I am trying to build an ever changing formula, that will list the contents from multiple work sheets. The trouble I have is sheets will be constantly deleted and added to the spreadsheet, meaning I ...
67
votes
8answers
231k 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
2answers
16 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
vote
1answer
18 views

Applying a custom sort to Google Sheets string column

I am trying to sort a table of rows by their first column that is comprised of strings with this format (capital letters followed by a dash followed by numbers). Using the default string sort I get ...
0
votes
1answer
40 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
39 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 ...
3
votes
1answer
3k 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 ...
3
votes
1answer
964 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
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 ...
1
vote
1answer
388 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., "...
0
votes
1answer
23 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
1answer
30 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
48 views

Creating Hyperlinks of Google Drive Items in Alphabetic Order

The original post that I got the google script editor code from was here: Get share link of multiple files in Google Drive to put in spreadsheet It works perfectly fine, but what I want to do is show ...
0
votes
0answers
25 views

Sort playlist by duration on Polymer YouTube

How can I sort my Watch Later playlist by duration on Polymer YouTube? I used to do this through a combination of ?disable_polymer=true, the Classic YouTube Firefox extension, and the Advanced ...
0
votes
1answer
34 views

Google spreadsheets sorting confusion when using formulas

I am sort of confused about the behavior when sorting by a columns content. I have this formula in A1: ={"Page";arrayformula(iferror(filter(Events!A16:A,Events!C16:C="Feedback R"),""))} I get the ...
0
votes
0answers
9 views

Google Drive sorting incorrect?

When I sort by name in my Google Drive, AB2010174-finaldox.pdf come before AB19260006-finaldox.pdf, which comes before AB20260009-finaldox.pdf. From what I understand about alphabetical sorting, The ...
0
votes
4answers
4k 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 ...
0
votes
0answers
20 views

How to use SORT function on existing data, and not make a copy of it

I am following this tutorial to sort data using a drop down menu and a check box. My only issue is that I want to use this method on the original set of data, and not make a copy of it. I would really ...
5
votes
3answers
6k 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 ...
2
votes
0answers
141 views

Auto sorting by multiple columns in Google Sheets

I have a data-set which I would like to have sorted with first column 6 and then column 7. From this post: How can I make some data on a Google Sheets auto-sorting? I have gotten ideas about making a ...
1
vote
1answer
4k 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 ...
-1
votes
2answers
2k 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 (...
3
votes
0answers
247 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 ...
-1
votes
1answer
14 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 ...
3
votes
1answer
395 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 ...
5
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
25 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 ...
1
vote
1answer
60 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?
12
votes
3answers
22k 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?
0
votes
3answers
378 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
31 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 ...
1
vote
1answer
58 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
506 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
17 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
17 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
78 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
569 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
39 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 ...
1
vote
1answer
67 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
933 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 ...
1
vote
0answers
63 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
9k 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
504 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 ...
4
votes
2answers
6k 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
1k 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
131 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 ...
2
votes
2answers
15k 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 ...