Questions tagged [sorting]
Sorting is the process of applying some order to a collection of items.
133
questions
0
votes
0
answers
10
views
How to match alphanumerical order in both Google Drive and Google Sheets? [closed]
I have a list of files on Google Drive with alphanumerical names. Here's an extract :
0a6ni0R15t.jpeg
0A6Wb1d9fR.pdf
0AST3tJxsL.pdf
0at6YAEPsF.pdf
0ayv9tyhtx.jpeg
0bBXj6h5BN.jpeg
0ciCHtBowY.jpeg
...
0
votes
0
answers
12
views
Any way to order Google search results by recency with descending date order?
As an example, I'll use "laughing cats" as the search term for "site:youtube.com". I'd like to sort or "order" the results by descending date (oldest to newest).
Here's ...
1
vote
1
answer
33
views
Organizing hierarchies in Google Sheets
I am currently using Google Sheets to organize and update the keywords I use in Adobe Lightroom (Photo organizing software) I'm trying to organize my keywords into hierarchies to make it easier to ...
1
vote
0
answers
13
views
Formula to automatically sort range of data into groups in different columns by colour?
I am an educator trying to find a way to automatically group students into broad groups of 'below' 'at' and 'above'.
My data is more specific (i.e. numerical value between 0 and 30) and I would like ...
0
votes
1
answer
32
views
I'm asking how to sort specific grouped rows
I have a question that seems similar to this one:
Sorting a sheet without losing group order
I want to sort the Rows on the 2nd Tab of the Spreadsheet ("Sorted Sheet"), so that the rows ...
0
votes
0
answers
16
views
Using Spreadsheet for timelines and non-fiction writing
I am creating a cold war timeline to write a history.
There are many entries, which consist of an "event" in one cell, a "date", a "place", and names of "people"...
0
votes
0
answers
11
views
searching and sort large amounts of data - how to do so quickly
I have about 3000 rows in each of two tabs on one Google sheet.
I have 7 columns of data (BH...BN) and 3000 rows in a tab called 'import sheet' and on a second sheet called 'stats', I have about 2000 ...
1
vote
0
answers
27
views
How to sort by descending date within a conversation in MS Outlook 365
I am using MS Outlook and I would like to sort emails based on conversation and then descending by date within each conversation so that the most recent email is at the TOP vs bottom.
I tried Arrange ...
1
vote
2
answers
40
views
How to sort a list-like text in a cell?
Suppose I have in a cell the following unsorted list-like text:
- VAL03
- VAL04
- VAL01
- VAL05
- VAL10
- VAL07
- VAL08
- VAL06
- VAL02
- VAL09
I would like to sort that list-like text. That is, in ...
0
votes
0
answers
52
views
YouTube Playlist - How to Sort Videos So the Newest Video Automatically Appears at the Top?
I have a question about sorting videos in my YouTube Playlists. I have 70+ preloaded videos labeled as Private. I sorted my Playlist by "Date Published (Newest)", but when I "Schedule&...
0
votes
1
answer
21
views
How to modify an existing advanced sort on a range?
I am a heavy user of Sheets and use advanced sorting by multiple columns all the time, but if I need to view HOW the range is ALREADY sorted or MODIFY the sort in any way, I cannot do it. I always ...
0
votes
1
answer
44
views
Google Sheets App Script Sorting
I'm trying to have an auto sort function only impact one sheet in a workbook rather than all of them. I've done this in other projects and def messed this up along the way - any help is appreciated!!
...
0
votes
1
answer
187
views
How to sort by percentage on Google Sheets
Now I am doing a tournament. So what I have right now is Column A is Character Names. Column B is their win Percentage. What I want is for Column C to have the Character Names in order by their Win ...
0
votes
1
answer
387
views
Auto Sort Google Sheet using onEdit Function and prioritising certain cell values
I have a populated table where I add a prioritisation queue number in the final column. The identification of each row is defined be email OR SMS and the prioritsation queue is labeled as such.
I ...
0
votes
0
answers
17
views
Sorting cells into past and future
I have a google sheet with the first column giving the dates of particular events. Ideally, I'd like to have two side by side versions of the spreadsheet, one with cells before todays date and one ...
0
votes
1
answer
100
views
Google Sheets Query: Order By and accented chars
In a Google Sheet, if we have a column with accented character strings, the sort order of menu option "Data -> Order sheet by column" correctly ignores the accents (ordered column A in ...
0
votes
0
answers
33
views
Automatically sort 1 sheet on edit
I have a google spreadsheet with multiple sheets.
On one of the sheets, we use Zapier to populate new rows of data when a meeting is scheduled with our team. I'd like the sheet "Meetings" ...
0
votes
1
answer
79
views
ORDER BY generating error in Google Sheets' QUERY
I'm getting a '#Value!' error when I try to sort data returned by a QUERY statement. This is the basic statement:
=query('Raw Data'!A:G,"Select A, C, D, sum(G) where B='instagram' and (D='Female ...
0
votes
0
answers
23
views
How to automatically custom sort a Google Sheet by status
I have to sort a sheet of data based on changeable values of dropdowns for each row.
For example, I want all the waiters that are on-shift to have a "Ready" status from the dropdown. Those ...
0
votes
0
answers
58
views
Sorting Named ranges in Google Sheets
I have many "named ranges" in a Google Workbook (multiple sheets with multiple named ranges on each sheet).
Is there a way to sort A to Z the named ranges? When I go to Data > Named ...
0
votes
2
answers
142
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
1
answer
625
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
1
answer
20
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
1
answer
132
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
1
answer
31
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
1
answer
20
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
1
answer
73
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
0
answers
26
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
1
answer
102
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 ...
4
votes
1
answer
791
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
1
answer
286
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;'...
1
vote
1
answer
396
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
1
answer
205
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
1
answer
46
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
1
answer
1k
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 ...
5
votes
0
answers
659
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
1
answer
1k
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
2
answers
33
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
3
answers
283
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
1
answer
95
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
3
answers
771
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
1
answer
79
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
1
answer
163
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
2
answers
1k
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
1
answer
31
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
1
answer
33
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
2
answers
3k
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
1
answer
140
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
1
answer
24
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
1
answer
20
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 ...