Skip to main content
Share Your Experience: Take the 2024 Developer Survey

Questions tagged [sorting]

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

Filter by
Sorted by
Tagged with
96 votes
10 answers
359k 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 ...
user avatar
18 votes
2 answers
3k views

Is it possible to sort your email in Gmail by something other than the date received?

I want to sort my email in Gmail by the sender, rather than the date received, is there a way to do this?
LBushkin's user avatar
  • 1,486
2 votes
1 answer
3k 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 ...
Michael's user avatar
  • 558
5 votes
1 answer
22k 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 ...
Phil Goetz's user avatar
5 votes
1 answer
8k 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 ...
Zom-B's user avatar
  • 391
5 votes
1 answer
2k views

How can I sort all worksheets in my Google spreadsheet on open?

I have successfully been able to sort the first sheet in my Google Spreadsheet onOpen, but I'd like to sort all four spreadsheets onOpen and I can't make this work. I've tried quite a few variations ...
Sarah's user avatar
  • 51
5 votes
3 answers
7k views

Sorting Google spreadsheet by month and day but not year

I made a Google spreadsheet with a list of birth dates, anniversaries, etc. that I would like to sort by when they occur in the year, not when they first happened. If you sort by the date normally, it ...
techturtle's user avatar
  • 1,040
4 votes
3 answers
4k views

Sorting unique rows by a related SUMIF column

I am putting together a worksheet to keep track of expenses. I currently have the following source table called "Expenses": A         B C D 1 Date Description Category Amount 2 1-Jan ...
jared's user avatar
  • 41
4 votes
1 answer
21k views

Sort Gmail by Date? [duplicate]

Possible Duplicate: Is it possible to sort your email in GMail by something other than the date received? Is there any way to sort Gmail by date in the web interface? The priority inbox is nice, ...
cwd's user avatar
  • 814
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,949
3 votes
1 answer
6k 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 ...
Joel's user avatar
  • 31
3 votes
2 answers
32k views

How to GROUP and ORDER data in a Google Spreadsheets?

I want to group and sort a particular data set. I've prepared the data using a QUERY function and using other functions. Can I order by sum? This is an example file I created: order by sum
Lucas Ribeiro Maia's user avatar
2 votes
1 answer
7k views

Filter Google Spreadsheet Array Formula

I have a spreadsheet with 2 columns. B1 contains a custom function that returns an array that overflows to fill the column. I want to create a few filter views that each show all entries with 1 given ...
DeadEli's user avatar
  • 273
2 votes
1 answer
1k views

How to make a column with several numbers in each cell sortable?

I am making an expenses spreadsheet in Google Docs and I need to list the numbers of the attachments for each entry. Sometimes this is just one number, sometimes it is several. I can make this ...
Nagel's user avatar
  • 183
2 votes
1 answer
183 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
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
4 answers
16k 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 ...
danstyx's user avatar
  • 25
1 vote
1 answer
1k views

YouTube Playlist Annoyances (Sorting, etc) [closed]

If I am viewing a video, and I wish to add it to a playlist of mine, I click on the Add to Playlist button. (I bet you're going, "No, duh.") The problem with this is: I have 18 playlists and ...
Mateen Ulhaq's user avatar
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 ...
Ben Carp's user avatar
  • 101
0 votes
3 answers
894 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