Questions tagged [sorting]

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

Filter by
Sorted by
Tagged with
0 votes
0 answers
16 views

Retain Row Formatting When Sorting

After performing a sort, the row's formatting doesn't retain it's row height and other custom format, and the row the data was in previously will retain the prior height/format instead of becoming the ...
Jinian's user avatar
  • 1
1 vote
1 answer
26 views

How do I get this to function on multiple sheets in a workbook?

I'm still fairly new to Apps Script. I found this answer several months ago and it's been working great, but I've been asked to implement it on several sheets in a workbook instead of just the initial ...
Phillip Shurtleff's user avatar
1 vote
0 answers
30 views

Gmail & Filters

I have set up filters in Gmail to attach a label to specific emails and have checked the box marked "skip inbox/put in the archive". However, some emails get marked with the correct label ...
liz's user avatar
  • 11
1 vote
1 answer
83 views

How do I ignore a few rows below the header (including header) when sorting data in sheets? [closed]

I want to leave the filter buttons at the top, where they are but begin sorting from where the checkboxes are.. Every way I try, the filter buttons move or it sorts the top "notes" area ...
Erik Koopmann's user avatar
1 vote
2 answers
353 views

When sharing a spreadsheet in "view only," frozen rows are included in "Sort A-Z"/"Sort Z-A"

Resources: You can see a copy of my spreadsheet in "View Only" mode here. To replicate my issue, just sort any column -- U is the one I've been doing. You can find a copy of my spreadsheet ...
Katie's user avatar
  • 11
3 votes
1 answer
38 views

Can I sort cells in Google Sheets with a key function?

I have some data in a Google Sheets document that I would like to sort by computing some value from two columns and using that as the sort key. Say my data is like this: A B C D 1 ... ... 8700 5 2 ....
JM0's user avatar
  • 131
0 votes
2 answers
839 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 ...
Johnny Utahh's user avatar
0 votes
1 answer
61 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 ...
Oli847's user avatar
  • 1
0 votes
0 answers
793 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?
LWC's user avatar
  • 1,278
2 votes
1 answer
128 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)) ...
Brooke's user avatar
  • 133
1 vote
2 answers
293 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 ...
Lance's user avatar
  • 277
1 vote
1 answer
21 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 ...
Sheetsrookie's user avatar
0 votes
1 answer
917 views

Why is Sort range not working?

In Google Sheets I have a column inProduction that contains one of the following text values: TRUE, FALSE, Z N/A. When I sort my range I expect the following order: # Ascending # Descending ...
WurmD's user avatar
  • 101
1 vote
1 answer
112 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. ...
Reverend Speed's user avatar
1 vote
1 answer
43 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-...
André Emery's user avatar
0 votes
2 answers
56 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 ...
Qelvin's user avatar
  • 3
1 vote
1 answer
571 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 ...
ylluminate's user avatar
1 vote
1 answer
73 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 ...
LightroomClassicCow's user avatar
1 vote
0 answers
18 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 ...
user296260's user avatar
0 votes
1 answer
267 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 ...
ArtisFun's user avatar
1 vote
1 answer
2k 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 ...
Chris's user avatar
  • 111
1 vote
2 answers
180 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 ...
Backo's user avatar
  • 113
0 votes
1 answer
153 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 ...
Kelley Canon's user avatar
1 vote
1 answer
1k 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!! ...
HelplessinHyannis's user avatar
0 votes
1 answer
1k 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 ...
Chillers's user avatar
1 vote
1 answer
3k 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 ...
Terry's user avatar
  • 11
1 vote
1 answer
480 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 ...
rafaelr's user avatar
  • 11
0 votes
0 answers
197 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" ...
Matthew D's user avatar
1 vote
1 answer
261 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 ...
S Jacobs's user avatar
0 votes
0 answers
92 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 ...
Liliya Kostadinova's user avatar
0 votes
2 answers
383 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 ...
Joe's user avatar
  • 1
0 votes
1 answer
2k 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 ...
Franck Dernoncourt's user avatar
0 votes
1 answer
65 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 ...
BRHSM's user avatar
  • 103
-1 votes
2 answers
536 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'...
Jacquie B PBJ's user avatar
1 vote
1 answer
112 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 ...
salyela's user avatar
  • 111
2 votes
1 answer
179 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 ...
sofname's user avatar
  • 137
2 votes
1 answer
46 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?
user67275's user avatar
  • 616
2 votes
1 answer
494 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 ...
Hassan Almaateeq's user avatar
7 votes
1 answer
2k views

Sort Gmail *search results* oldest first [duplicate]

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 ...
Jason C's user avatar
  • 367
1 vote
1 answer
524 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;'...
Colin Woodward's user avatar
1 vote
1 answer
770 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 ...
Addie's user avatar
  • 121
1 vote
1 answer
369 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 ...
KLonge's user avatar
  • 23
0 votes
1 answer
71 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 ...
bewww's user avatar
  • 3
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 ...
Jesper Homann 's user avatar
5 votes
1 answer
953 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 ...
PinkSamurai Fairlady's user avatar
4 votes
1 answer
2k 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 ...
sam's user avatar
  • 6,899
1 vote
2 answers
51 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 ...
Erin's user avatar
  • 11
-1 votes
3 answers
1k 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 ...
user225620's user avatar
0 votes
2 answers
738 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 ...
Clay Harper's user avatar
0 votes
3 answers
892 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 ...
Yosief Ellaham's user avatar