Questions tagged [sorting]
Sorting is the process of applying some order to a collection of items.
17
questions
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 ...
Diego Petrucci
15
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?
- 1,446
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 ...
- 528
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 ...
- 1,040
4
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 ...
- 370
4
votes
1
answer
21k
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 ...
- 148
4
votes
1
answer
3k
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 ...
- 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, ...
- 784
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 ...
- 31
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 ...
- 6,705
3
votes
2
answers
29k
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
2
votes
1
answer
106
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 ...
- 137
2
votes
1
answer
1k
views
In Google Docs, 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 ...
- 183
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 ...
- 263
1
vote
4
answers
15k
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 ...
- 25
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 ...
- 101
0
votes
3
answers
855
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 ...
