Questions tagged [sorting]

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

Filter by
Sorted by
Tagged with
1
vote
2answers
14k 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
1
vote
2answers
537 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
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
vote
1answer
140 views

Sort auto update

I have this table, which is a ranking, whose values are updated automatically (data gathered from other files). What I want is that every time these values are updated the ranking automatically ...
1
vote
1answer
34 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 ...
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
2answers
434 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 ...
1
vote
1answer
76 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
1answer
2k views

Auto sort script sorting different sheets by different columns

I have a master sheet where data is entered. I would like the other sheets in the book (which currently auto-populate from the master sheet) to sort (in descending order) by their respective column in ...
1
vote
1answer
2k views

How to combine and consolidate rows from multiple sheets into one and sort them?

I've few sheets where rows are populated dynamically via IMPORTXML and ImportJSON with the same columns, but they can't be sorted. So I'd like to generate new sheet which will populate rows from ...
1
vote
1answer
193 views

Is there any way sort Trello cards by custom values?

I sort my bucket list by a ((how much it excites me)*(how much value it will bring me)*(probability of success)/(cost in hours)*(days until [self-imposed] deadline)). Is there any way to assign such ...
1
vote
1answer
112 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() ....
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?
1
vote
1answer
42 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
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
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
66 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 ...
1
vote
0answers
60 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 ...
1
vote
0answers
79 views

Change default sorting on Google Analytics' Dashboard page

We have implemented Google Analytics (GA) for our website and ended up creating 25 dashboards. The issue is every time I go to the Customisation => Dashboards on GA, it shows the dashboards sorted by ...
1
vote
1answer
362 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., "...
1
vote
0answers
565 views

How to automatically sort a filtered list that's always changing in Google Sheets?

I have a complex spreadsheet that rolls up data from all over the place into a filtered list. We need to sort this filtered list, along with notes added afterward in columns to the right of the filter....
1
vote
0answers
54 views

How to sort posts by topic from people I follow on Pinterest

I want to be able to sort the pins from people I follow by topic. So I want to be able to see only Food posts from people I follow (or Fashion or whatever), not from everyone. Is there any way to do ...
1
vote
1answer
82 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.
1
vote
2answers
218 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
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
3answers
352 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 ...
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....
0
votes
1answer
2k views

Help with ordering a Google Sheets =QUERY

I'm trying to add an ORDER by F to the following query, but every time I do it returns a syntax error. ORIGINAL QUERY (working) =QUERY(data!A2:Z, "select G, E, F, I, J WHERE A = " & C1, "") ...
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 ...
0
votes
1answer
5k 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 ...
0
votes
1answer
128 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 ...
0
votes
1answer
2k views

How to filter range and return only specific columns?

This is what I have tried just yet: =QUERY(FILTER(Recherche!A4:O1002), "select Col1, Col15, Col2, Col3, Col4") based on this format =QUERY(FILTER(B:D,D:D>=2),"select Col2, Col1") What I get is ...
0
votes
2answers
203 views

Sorting Google Sheets by Mailing Address

I have a spreadsheet in Google Sheets (and Excel) that contains companies from many countries. The address cell has the full address including the country. So: Company name | Full Address | phone ...
0
votes
1answer
1k views

How to sort spreadsheet by date+time column but with a modified hour column?

I have a spreadsheet generated by a Google form and it produces a standard spreadsheet with a full timestamp column, that is two hours behind, and an hour column (hh:mm am/pm) that the user fills in ...
0
votes
1answer
43 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, so ...
0
votes
1answer
4k views

Sort Google Drive by date added [duplicate]

Is there a way to sort Google Drive (either iOS or web version) by date that a file was added? It drives me crazy that if I use Gmail to save an attachment to Drive, I can't locate that file ...
0
votes
1answer
10k 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 ...
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 ...
0
votes
0answers
15 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
32 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
0answers
19 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 ...
0
votes
0answers
34 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
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 ...
0
votes
1answer
32 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
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
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
29 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, ...
0
votes
1answer
39 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
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 ...