Questions tagged [sorting]

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

Filter by
Sorted by
Tagged with
1
vote
1answer
55 views

Sort all my j.mp links by most clicked

Is there any way I can get all of the links associated with my j.mp account and arrange them so that the links with the most clicks are at the top?
3
votes
1answer
715 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, ...
3
votes
1answer
976 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 ...
1
vote
1answer
217 views

Filter View: Sort by custom string order

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., "...
10
votes
3answers
16k views

How can I alphabetize a unique result in Google Spreadsheets?

I'm generating a list based on using the UNIQUE function. How can I get the output to be alphabetized automatically?
0
votes
1answer
8 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 ...
57
votes
6answers
173k 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 ...
0
votes
1answer
20 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
3answers
66 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
1answer
23 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 ...
0
votes
2answers
151 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
1answer
14 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
1answer
17 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
2answers
38 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
1answer
15 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 ...
0
votes
1answer
11 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 ...
0
votes
1answer
8 views

Sorting column A with drop-down and column B with checkbox

I have a spreadsheet that I use to run a foosball tournament, and in column A I have a dropdown data validation that will let me select a players name. In Column B I have a checkbox that I check once ...
1
vote
1answer
13 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. ...
1
vote
1answer
41 views

Sort Google Spreadsheets so it returns 'alternating' values in a column

How can I sort a random list in Google Sheets so it returns alternating values? The current random list looks like this: fName lName Room ID ----------------------------------- Sara Don ...
1
vote
2answers
379 views

Sort a Google Spreadsheets so it returns 'alternating' values in a column

I have a list of hundreds of students that contains the following data. The only two values that will appear in the gender column (col 3) are male or female: Current List fName | lName | ...
0
votes
1answer
33 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 ...
0
votes
1answer
154 views

Is it possible to make a custom sort on column other than A-Z or Z-A in Google Sheets?

The Sheet has a column with cells populated by a dropdown list offering 3 choices: Good; Very Good; Rejected; In that context, it would be practical to sort the column according to a specific/custom ...
1
vote
1answer
22 views

Sort by a Column While Maintaining Information in a Row

I had a previous question with lots of support and it solved my problem. The next issue I have is sorting the data while bringing the information in the corresponding row with it. A link to the ...
0
votes
3answers
361 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 ...
1
vote
1answer
48 views

Combing two ranges with identical column structure from two different sheets (in same spreadsheet)

I'm doing a simple ticketing system, where I have two sheets, "Form Responses" and "Email Responses" both of which are populated automatically as their names imply (one from a form, one from an email ...
0
votes
1answer
918 views

YouTube Playlist Annoyances (Sorting, etc)

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 ...
0
votes
0answers
93 views

How to auto-sort from a drop down box?

Without having to manually auto sort alphabetically, how can I get it to automatically sort when creating a new project and choosing A,B,or C, from the drop down menu in the the first column. See ...
1
vote
0answers
21 views

How do I sort Glassdoor reviews by rating on a computer?

The Glassdoor mobile app in both iOS and Android has an option to sort and filter reviews. As far as I know this does not exist on the computer version of the Web App. How do I sort Glassdoor ...
2
votes
3answers
7k views

Auto sort of Forms responses so that the most recent one is on top

We use Google Forms to collect guest surveys for our resort. New responses get added to the bottom of the response sheet. While we can manually sort the responses using the time-stamp feature, not ...
3
votes
0answers
400 views

How to sort Youtube subscriptions by updates?

When I enter YT on the left pane I have "Subscriptions" section sorted by the date of the subscription. So as the effect I could have: Subscriptions A D 1 E F G 7 --- show more --- B 3 ...
2
votes
2answers
3k views

Google Sheets, how to sort query results manually (Not in query)

My google sheet is importing data from another tab just for sorting purpose, however, when the sort is done manually (through Google Sheet menus), results are unpredictable. The sheet is populated ...
0
votes
0answers
668 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 ...
0
votes
1answer
110 views

I need help with sorting query in Google Sheets

I have a zap that pulls "Email" data from a spreadsheet, I also have a query that pulls "NAME" data from a different spreadsheet, but when I try to sort it, the data gets misplaced, eg. blank rows ...
1
vote
2answers
9k 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
0
votes
2answers
1k views

How do we actually do list sorting in Google Bookmarks (alphabetical order)

I use Google Bookmarks and I’d need a way to sort all my lists in alphabetical order. The "My lists" current has itself sorted in last modified order... and although that’s useful, it is more useful ...
0
votes
1answer
38 views

spreadsheet conditional: if in top x then

spreadsheet data: Total Average Highest Top Sales $23,550.00 $7,850.00 $8,100.00 not $42,700.00 $14,233.33 $14,400.00 not $30,500.00 $10,166.67 $10,300.00 not $37,840.00 $12,613....
2
votes
1answer
2k views

Sorting on a web-published Google Spreadsheet

I have a Google Spreadsheet that is published to the web and embedded in a website. This spreadsheet has data about hotel rooms, such as hotel name, number of rooms, date in and out, etc. I would ...
4
votes
0answers
177 views

Sort Delicious bookmarks from all users by popularity

When on the Delicious homepage there is the hotlist > popular bookmarks. This only shows very few bookmarks. Doesn't seem to be actually tagged bookmarks ranked by number of times saved by different ...
0
votes
1answer
3k 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 ...
4
votes
3answers
4k 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, ...
7
votes
2answers
198 views

Sort Gmail messages by how long people have been waiting for a reply

I am trying to help someone break the habit of delaying too long in replying to emails. For a select group of email senders in Gmail, I'd like to set up some way of seeing how long it has been since ...
0
votes
1answer
36 views

Is it possible to sort topics in Rizzoma by number of votes?

Overview As Google Moderator is shutting down on June 30, 2015 (more Info) I would like to learn about alternatives, mainly for educators. Rizzoma topics could include the Yes/No/Maybe Wave gadget, ...
3
votes
1answer
411 views

How can you change the sort order in reader view?

I'm one of the many people jumping early from Google Reader in wake of the announcement to look for replacements. I'm quite happy with Netvibes' reader view, which is almost exactly what I had with ...
1
vote
1answer
1k views

Auto sort script sorting different sheets by different columns

I have a master sheet where data is entered. I would like the other sheets in the book (which currently auto-populate from the master sheet) to sort (in descending order) by their respective column in ...
0
votes
1answer
2k views

Help with ordering a Google Sheets =QUERY

I'm trying to add an ORDER by F to the following query, but every time I do it returns a syntax error. ORIGINAL QUERY (working) =QUERY(data!A2:Z, "select G, E, F, I, J WHERE A = " & C1, "") ...
-2
votes
1answer
1k views

How to sort names in column alphabetically ignoring “The”, “An” & “A”… and then pull names (skipping duplicates) into another tab [closed]

This is for a Movie Have/Want list using Google Sheets. Problem 1: Column A is the movie Title. I would like to be able to sort the movie titles alphabetically but ignore when a movie title begins ...
0
votes
1answer
916 views

How to sort spreadsheet by date+time column but with a modified hour column?

I have a spreadsheet generated by a Google form and it produces a standard spreadsheet with a full timestamp column, that is two hours behind, and an hour column (hh:mm am/pm) that the user fills in ...
4
votes
1answer
2k 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 ...
2
votes
1answer
110 views

Is there a function I can enable to have a Check List action item populate in multiple boards I select?

I have an "Active Projects" board that has about 60 lists each representing a company I manage. Each company has 1-5 cards representing projects we are working on. Each card has a "TO DO" checklist. ...
1
vote
1answer
136 views

Sort auto update

I have this table, which is a ranking, whose values are updated automatically (data gathered from other files). What I want is that every time these values are updated the ranking automatically ...