Questions tagged [sorting]
Sorting is the process of applying some order to a collection of items.
106
questions
0
votes
1answer
26 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 ...
-2
votes
0answers
15 views
Any way to store/save money online?
This is kind of complicated. For example, PayPal Balance. I can't use that because it requires a Bank Account. I want to spend big on something. For example £500. I don't want to spend the money at ...
0
votes
0answers
7 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
44 views
How to download attachments of Gmail mail automatically? then move each file to a folder according to file name
I want to connect to Gmail and download all new attachments daily locally no google drive involvment then i want to sort them all in premade folders according to file name (like each file starts with ...
0
votes
0answers
18 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 ...
2
votes
0answers
63 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
0answers
72 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 ...
0
votes
0answers
31 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|...
2
votes
1answer
226 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 ...
0
votes
2answers
15 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
3answers
24 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
21 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
3answers
280 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
30 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
34 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
321 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
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 ...
-1
votes
2answers
1k 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
27 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
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.
...
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
66 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
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 ...
0
votes
1answer
36 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 ...
1
vote
1answer
37 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
4answers
2k 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
63 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
50 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 ...
3
votes
2answers
5k 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
998 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 ...
3
votes
0answers
476 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
...
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....
1
vote
1answer
1k 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 ...
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
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 ...
1
vote
0answers
75 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 ...
0
votes
1answer
127 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 ...
5
votes
2answers
2k 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?) ...
1
vote
1answer
298 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
2answers
493 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 | ...
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
139 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 ...
1
vote
0answers
546 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....
3
votes
1answer
11k 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 ...
3
votes
1answer
2k 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 ...
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 ...
4
votes
1answer
5k 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 ...
3
votes
1answer
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 ...
1
vote
1answer
3k 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 ...
