Questions tagged [sorting]
Sorting is the process of applying some order to a collection of items.
138
questions
0
votes
2
answers
29
views
Google Sheets keyboard shortcut: 'Sort sheet AtoZ or ZtoA' on current column?
How can I make a Google Sheets keyboard shortcut for both Sort sheet A to Z and Sort sheet Z to A on the current column (if one does not already exist)?
I'm constantly GUI-header-clicking a pop-up ...
- 127
5
votes
1
answer
767
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 ...
CommunityBot
- 1
1
vote
1
answer
39
views
How to order column groups by a cell's value
I have a spreadsheet of multiple datasets in columns. I checked some documentation here, https://support.google.com/docs/answer/3093150, but the SORT() function would order my columns on a column-by-...
CommunityBot
- 1
1
vote
2
answers
43
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 ...
CommunityBot
- 1
1
vote
1
answer
736
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 ...
CommunityBot
- 1
0
votes
1
answer
2k
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 ...
CommunityBot
- 1
1
vote
1
answer
58
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 ...
CommunityBot
- 1
0
votes
1
answer
56
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 ...
CommunityBot
- 1
0
votes
1
answer
28
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.
CommunityBot
- 1
0
votes
1
answer
314
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 ...
CommunityBot
- 1
3
votes
1
answer
2k
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, ...
CommunityBot
- 1
-4
votes
1
answer
2k
views
Simple row references in Google Spreadsheets and resorting data
This is my scenario
Users are entering data into rows with several columns
Last column is calculated on values of few previous columns (so it's row number independent).
While entering new and ...
- 43.3k
2
votes
1
answer
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 ...
CommunityBot
- 1
1
vote
1
answer
711
views
Filter View: Sort by custom string order [closed]
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., "...
CommunityBot
- 1
1
vote
1
answer
594
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 ...
CommunityBot
- 1
6
votes
1
answer
1k
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 ...
CommunityBot
- 1
1
vote
1
answer
34
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 ...
CommunityBot
- 1
0
votes
1
answer
323
views
Why is Sort range not working?
Minimal example: https://docs.google.com/spreadsheets/d/168bq72DGKNxNLXt-Jzbh95iQ2Gu93IzmPp38SB0od5E/edit?usp=sharing
inProduction velocity(%)
TRUE 0.027192
TRUE 0.026422
TRUE 0.246903
...
CommunityBot
- 1
1
vote
1
answer
13
views
How do I sort indexed data from a form and maintain list from a range input added afterwards?
I want to sort the responses by names alphabetically Column A (Simple)
I want to apply payment types from a drop down linked to the person's name Column G (Simple)
I want to do both of these things ...
CommunityBot
- 1
1
vote
1
answer
884
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!!
...
CommunityBot
- 1
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 ...
CommunityBot
- 1
1
vote
1
answer
271
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 ...
CommunityBot
- 1
0
votes
1
answer
408
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, ...
CommunityBot
- 1
1
vote
1
answer
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 ...
CommunityBot
- 1
1
vote
1
answer
190
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 ...
CommunityBot
- 1
0
votes
0
answers
15
views
Sorting by dates [duplicate]
I'm trying to sort dates in Google Sheets and ran into a problem.
I have many dates consisting of a day and month. DD/MM
When sorting sheets does this:
01/01
01/02
03/02
04/01
07/01
09/02
15/01
And ...
- 43.3k
0
votes
1
answer
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 ...
- 43.3k
0
votes
1
answer
29
views
Google Sheets - Auto group and sort
I've got a bunch of data, in this instance it's lists of fixtures for my son's juniors football team, which I'd like to order for ease. The age group is split into sub teams, e.g. U10 Reds, U10 Blues ...
- 11.2k
1
vote
1
answer
184
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 ...
- 43.3k
2
votes
1
answer
44
views
How is alphabetization determined in Excel and Google Sheets?
I was recently sorting data in Google Sheets that involved the word "hello" in various languages. An excerpt of this sheet is below. Column C was calculated using the =UNICODE(LEFT(B2,1)) ...
- 2,496
0
votes
0
answers
168
views
How to sort pivot columns in Looker Studio in Viewer mode?
If it's a table, all one has to do is click the column's title or right click and choose Sort By:
[
How can the same be achieved to pivot tables?
- 1,182
-1
votes
2
answers
315
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'...
- 1
2
votes
1
answer
39
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?
- 501
1
vote
2
answers
128
views
How to sort by word length, then alphabetically, in Google Sheets?
I have this local JavaScript function to sort the way I'm describing:
const lines = ['foo', 'bing', 'world', 'baz', 'hello', 'bar', 'blank']
.sort((a, b) => {
const len = a.length - b.length
...
- 1,040
1
vote
1
answer
50
views
How can I 'save' a cell order in columns in Google sheets, sort the column to a different order, then reload the earlier cell order?
I'm building a quote for a client, based on their list of tasks.
I've entered these tasks in his order down along my first column (a).
My first row (1) is a collection of headings, which I've frozen.
...
- 2,496
0
votes
2
answers
49
views
Google Spreadsheets-Autosort but with a second argument
This is the link to a Google Spreadsheet for use in a fishing club.
https://docs.google.com/spreadsheets/d/17xFDHoF_-3Kg7jVrxiIRjBJy-DD70RFg6wPf19fQC50/edit#gid=943629989
When the fishing tournament ...
- 5,208
1
vote
1
answer
39
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 ...
- 2,496
5
votes
3
answers
9k
views
Sorting title with numbers in Google Drive
When I sort by title in Google Drive, I would like it to numerically go 1 → 2 → 3 … etc., but instead it goes 1 → 10 → 100 → 1000 → 1001 → 1002 … etc.
Is there any way to get it to do the first ...
1
vote
0
answers
16
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 ...
- 9,828
0
votes
1
answer
47
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 ...
- 9,828
1
vote
2
answers
78
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 ...
- 4,820
0
votes
1
answer
26
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 ...
- 9,828
1
vote
1
answer
269
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
6
votes
2
answers
3k
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 ...
- 2,226
0
votes
0
answers
141
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" ...
- 43.3k
91
votes
10
answers
335k
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 ...
- 103
0
votes
0
answers
39
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 ...
- 9,828
4
votes
3
answers
5k
views
Sorting Gmail contacts by date
Is it possible to sort Gmail contacts by date?
I want to see the last contacts added and couldn't find a way to do this. The only option I see is by first and last name.
- 101
0
votes
2
answers
250
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 ...
- 11.2k
0
votes
1
answer
1k
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 ...
CommunityBot
- 1