Questions tagged [sorting]
Sorting is the process of applying some order to a collection of items.
114
questions
0
votes
2answers
33 views
Google sheets Sort by Header in View Mode
I wanna create a sheet with multiple columns of data... I would like to put sort options on the header columns.. so if one of the column is named PLAYERS NAME and then another Header is named AT BATS ...
0
votes
1answer
35 views
How can one swap 2 columns in Microsoft Excel 365 if the sheet contains a sortable table?
I have a Microsoft Excel 365 file with a sheet containing a sortable table:
How can I swap 2 columns in this sheet (e.g., swap column H with column I)?
What I have tried unsuccessfully:
Select ...
0
votes
1answer
16 views
Can I quickly sort Google Sheet via buttons?
I've got a Google Sheets document with a lot of data that I often need to sort. Google Sheets offers a sorting feature but I'd personally like button on the header that allows sorting of the rows ...
-1
votes
1answer
13 views
Problems when sorting a Google sheet that someone else is editing
In the past, when two people were editing the same Google sheet, if person A attempted to do a sort they would get a "heads-up" warning that A's sort was going to affect person B.
We now don'...
0
votes
1answer
18 views
How to sort by merged cells in Google Sheet
I have been using this script for sorting and so I know it works. Now I'm trying to use it on a new Google Sheet project. Except that the column I want to sort the entire sheet by isn't just one ...
0
votes
1answer
13 views
Auto sorting multiple column
Can we auto sort multiple column in Google Sheet without using script?
I can't open the script so I can't try the proposed script here.
2
votes
1answer
65 views
How to use a query to find a row of same name but last entry, then copy a value next to it
I am trying to use a query to copy values from one column to another.
Both source and destination columns have a name on their left columns, and the name must match. The source names could be ...
2
votes
0answers
23 views
Sort email by the number of unread messages in Gmail web
I would like to sort the email senders by the number of unread messages.
In the web version of Gmail, they don't support this feature as far as I know.
How can I do this?
2
votes
1answer
69 views
How to sort a column based on specific text in Google Sheet
I have the following:
=sort(filter('CASES LIST'!C:R,('CASES LIST'!Q:Q="admission")+('CASES LIST'!Q:Q="pending")+('CASES LIST'!Q:Q="PCI")),16,true)
but I want to sort in ...
3
votes
1answer
233 views
Sort Gmail *search results* oldest first
Mail can be sorted oldest to newest in Gmail by clicking on the email count and choosing Oldest. However, for search results, the sort order selections seem to be disabled:
Is it possible to sort ...
1
vote
1answer
63 views
Google Sheets - Sort results of query by column B (count)
I have this query
=QUERY({'2008'!A2:A500;'2009'!A2:A500;'2010'!A2:A500;'2011'!A2:A500;'2012'!A2:A500;'2013'!A2:A1000;'2014'!A2:A1000;'2015'!A2:A1000;'2016'!A2:A1000;'2017'!A2:A1000;'2018'!A2:A1000;'...
0
votes
0answers
5 views
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 ...
1
vote
1answer
140 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 ...
1
vote
1answer
101 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
1answer
37 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
510 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 ...
4
votes
0answers
559 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 ...
3
votes
1answer
898 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
23 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
67 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
61 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
638 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
34 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
100 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
784 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
25 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
22 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
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 (...
0
votes
1answer
45 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
22 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
17 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
86 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
19 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
47 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
43 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
4answers
8k 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
70 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
70 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 ...
4
votes
2answers
7k 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
1answer
2k 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
536 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
...
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 ...
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
6k 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
96 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
146 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
505 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
675 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 ...
