Better Sheets

Login

Get Instant Access

Formulas > =SORT()

How To Use SORT() Function in Google Sheets

Description

Sorts the rows of a given array or range by the values in one or more columns.

The SORT formula can be used to sort data in a range of cells in ascending or descending order. It can also be used to sort data by multiple columns.

The SORT formula is commonly mistyped as SORTED, or SORTING, or ASORT, or SORTER.

Some common ways the SORT formula is used inappropriately include sorting data that is not in a range of cells, sorting data that is not in the same format. A common error might be to try to sort dates that are not dates at all. Labeling dates of the week as "Monday" or "Tuesday" does not mean that a sort function will correctly know that the days of the weeks should be sorted by their order of days. It will try to sort them alphabetically.

Common pitfalls when using the SORT formula include forgetting to specify the range of cells to be sorted, forgetting to specify the order of sorting, and forgetting to specify the column to be sorted.

Common mistakes when using the SORT formula include using the wrong syntax, using the wrong arguments, and using the wrong order of sorting. You might want to sort a whole column and put the column name in quotes. That is a simple mistake to make as some formulas such as INDIRECT do need the arguments to be in quotes to work as intended.

How To Actually Use SORT() in Sheets

SORT(range, sort_column, is_ascending, [sort_column2], [is_ascending2])

Google Docs Help

11Better Sheets Tutorials

Replace 1,000 Formulas Instantly

Learn a cool trick you can do with the ArrayFormula. If you don't know what the ArrayFormula does, I show you how to use it in the first few minutes of this video. Then show you how to use it better.

ARRAYFORMULA() SORT()

Optimize SEO with Google Sheets and Google Search Console

Use Google Sheets to quickly find pages we can optimize. Using data directly from Google Search Console. Also check out the simple formula combination: AND() with IF()

IF() FILTER() SORT() AND()

Better Sheets Videos Checklist

How to create a video checklist. Create a sheet with check boxes that you check off to mark the videos as seen. Great for those creating lead magnets or checklist digital products. Enables you to create a video course without having to download/upload any videos. Your users can keep track of their progress and get all the benefit of your knowledge.

Data validation Beginner

FILTER() SORT() SPARKLINE() COUNTIF() COUNTA() +1 more

Alejandro Asks: How do I Sum up Study hours from a Calendar Format?

A member, Alejandro, asks about taking their custom calendar inputs and figuring out study totals for a week. They created a beautiful input and just need to the calculations. I show how to use the data to do the calculations. If you've never used the FLATTEN() formula, this is a good example! And we use double UNIQUE().

FLATTEN() FILTER() SUM() UNIQUE() SORT()

Twitter Sort Tool

I'll show you how I created a Twitter tool sort to organize my list of every tool I use to run better sheets.
Paste a list into Sheets and using a simple formula, I was able to determine the length of each item.

Then, I sorted the list in ascending order based on the length column. I even experimented with sorting it in descending order too!

Finally, I deleted the original list and pasted the sorted one using the "paste values" option. It's all done and ready to be shared. Check it out and let me know what you think! Don't forget to tweet about it if you find it helpful. Enjoy

SORT() LEN()

Combine Sheets Into One Sheet As It Happens

Jodi asked: ab out Building a sales CRM spreadsheet that has 4-5 tabs at the bottom. Each sales person gets their own sheet and then I want a master spreadsheet that pulls each salespersons Information they enter (customer, job, status etc) into one place.

I’m not sure how to get the master sheet to pull in from the other sheets as they enter the data so that the master sheet shows real-time what’s happening without making one row = a row from another sheet. I just want it to come in one row after the next as it happens.

Other Videos Mentioned in this video:
https://bettersheets.co/tutorials/add-a-timestamp-to-task-lists-without-now-formula
https://bettersheets.co/tutorials/spreadsheet-automation-101-lesson-2-onedit-trigger

Spreadsheet Automation 101: https://bettersheets.co/courses/spreadsheet-automation-101

Intermediate

IMPORTRANGE() SORT()

Discover Misspelled Duplicates

Discover effective methods to handle misspelled duplicates in Google Sheets using formulas without destroying your data. Search and find duplicates that are spelled differently.

Unveiling the Art of Taming Misspelled Duplicates: A Harmonious Symphony of Google Sheets Tricks and Tips

Embark on a captivating journey as we unravel enchanting secrets in this video guide.

Discover an ethereal dance of formulas that transcends the limitations of Google Sheets' native features, gracefully addressing the conundrum of misspelled duplicates.

Delve into the profound intricacies of the issue, where statuses and names intertwine, inviting chaos into your CRM or meeting records.

Witness the mesmerizing revelation of unorthodox yet elegant techniques that preserve your data's essence without sacrificing its integrity. Unveil the hidden world of the duplicate detector, where rows are harmoniously synchronized, leaving no spelling errors unnoticed.

Prepare to be enchanted by the sublime artistry of equals unique, a symphony of transformation that transforms hundreds or thousands of rows into a carefully curated masterpiece. Immerse yourself in this poetic quest and unlock the mystique of finding truth amidst a sea of missteps.

UPPER() ARRAYFORMULA() UNIQUE() SORT() LOWER() +1 more

Anika Asks: How to Bring value from other cells | How to Reference an array in a cell

She has a cell, this D one, in which it says, for instance, another array or a row or column in this case, a column, a on sheet one where we're on and she's referencing that from another cell.

INDIRECT() TRANSPOSE() SORT()

Count How Many Subscribers In a Company by BetterSheets.co

I download it from MailChimp and then I try to figure out which companies are subscribed to me most. And I do, I have to figure out the domain and count the domain. And we're gonna do that all in Google Sheets.

COUNTIF() SORT() LOWER() SPLIT() UNIQUE() +1 more

Vertically Stack and Sort Data

It's a common problem: combining two lists of scores to identify top performers using Google Sheets. We demonstrate how to sort data from two different ranges using the VSTACK function and also using curly brackets. Learn the step-by-step process to create a single, vertically stacked dataset that can be sorted effectively.

VSTACK() SORT()

Americano Tournament Template With Four Automations

Created a tournament template with 4 automations. So tabs can be copied by a laptop, ipad, or mobile.

UNIQUE() SORT() SUMIF() SUM()

Learn more about the SORT() formula:

How to use the SORT function in Google Sheets (Syntax & 6 Examples)

The Google Sheets SORT function allows you to sort data and return the rows in a range either in ascending or descending order. The SORT function also allows you to add multiple criteria across columns, in a similar way to the “Sort Range” functionality in the Google Sheets menu bar. The difference is that with the SORT function you can generate a new set of data while the original data remains intact. You can use it to sort data alphabetically, numerically, or even by date, and you can sort both vertically and horizontally.

Generate a SORT() formula for your needs with AI

Google Sheets Formula Generator

Whatever you need to do in sheets, you can generate a formula. Use the Better Sheets Formula generator to create a formula for any need. Completely free for members.

Looking for more help inside sheets get the free Add-on: Asa. Ask Sheets Anything. Go ahead, ask it any problem you migth have. Bring your own APIKEY and generate formulas inside of Google Sheets.

Better Sheets

Something for everyone to Learn Google Sheets. Includes Google Sheets for Beginners and Advanced Google Sheets Tutorials alike.

Get Started Now

Google Sheets Help

Google Sheets Courses

Google Sheet Templates and Tools

Google Sheet Add Ons