Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [sorting]

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

3
votes
1answer
664 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
957 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 ...
2
votes
1answer
172 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., "...
1
vote
1answer
50 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?
0
votes
1answer
24 views

Google Sheets advanced alternate custom sorting

For example, I have a random list of students in different rooms 101, different gender, and 4 different categories. The list might grow and students might be added in new rooms or existing rooms. How ...
0
votes
1answer
7 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. ...
0
votes
1answer
6 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
5 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 ...
0
votes
1answer
32 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
57 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 ...
-3
votes
1answer
1k 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 ...
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 ...
3
votes
0answers
784 views

How to display and sort all Google+ posts based on most voted video/photo?

I would like to display all Google+ posts into my website and I would like to categorise them into: most voted video/photo most recent video/photo How can I achieve the above? I know how to embed ...
3
votes
0answers
337 views

How to make “Highest Rated” the default on yelp.com

Whenever I start a new search on Yelp, it sets the sort order to "Best Match." Is there a way to have the default be "Highest Rated" instead? If I can't figure anything else out, I'll set up a ...
2
votes
0answers
351 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 ...
1
vote
0answers
14 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 ...
1
vote
0answers
51 views

Change default sorting on Google Analytics' Dashboard page

We have implemented Google Analytics (GA) for our website and ended up creating 25 dashboards. The issue is every time I go to the Customisation => Dashboards on GA, it shows the dashboards sorted by ...
1
vote
0answers
462 views

How to automatically sort a filtered list that's always changing in Google Sheets?

I have a complex spreadsheet that rolls up data from all over the place into a filtered list. We need to sort this filtered list, along with notes added afterward in columns to the right of the filter....
1
vote
0answers
54 views

How to sort posts by topic from people I follow on Pinterest

I want to be able to sort the pins from people I follow by topic. So I want to be able to see only Food posts from people I follow (or Fashion or whatever), not from everyone. Is there any way to do ...
0
votes
0answers
20 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 ...
0
votes
0answers
404 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
0answers
9 views

How to sort emails in folders but also keep them in the inbox (Outlook)

How to sort emails into different folders (by names) AND keep them in the inbox folder? I'm assuming some sort of copy creating thing...?
0
votes
0answers
2k views

How to automatically sort Google Sheet data with a hierarchy

I would like to know how to make it so that it sorts by subscriber count(Lowest to Highest) ➜ Have contacted (Yes is first and no is last) ➜ If they have accepted it on the top if they haven't ...