Formulas > =SORTN()

How To Use SORTN() Function in Google Sheets


Returns the first n items in a data set after performing a sort.

Common Questions about the SORTN Formula:
1. What is the SORTN formula?
2. How does the SORTN formula work?
3. What are the parameters of the SORTN formula?

How can the SORTN Formula be used appropriately?

The SORTN 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 based on specific criteria, such as sorting by a specific column or by a specific value.

How can the SORTN Formula be commonly mistyped?

The SORTN formula is commonly mistyped as SORT or SORTN.

What are some common ways the SORTN Formula is used inappropriately?

The SORTN formula should not be used to sort data that is not in a range of cells. It should also not be used to sort data that is not in a specific order, such as alphabetical or numerical order.

What are some common pitfalls when using the SORTN Formula?

The SORTN formula can be difficult to use if the data is not in a range of cells or if the data is not in a specific order. Additionally, the SORTN formula can be difficult to use if the data is not formatted correctly.

What are common mistakes when using the SORTN Formula?

Common mistakes when using the SORTN formula include not specifying the range of cells to be sorted, not specifying the order of the sort, and not specifying the criteria for the sort. Additionally, it is important to make sure that the data is formatted correctly before using the SORTN formula.

Google Sheet Formula Frustrations Solved
Find every formula you'll ever need in Google Sheets here at Better Sheets. Whether you're a beginner or an advanced user, I’ve got you covered with a comprehensive guide of 504 formulas.

Are you struggling to find a specific value in a column of data? Look no further than the powerful VLOOKUP formula. Or maybe you need to calculate the sum of values that meet specific criteria - try out SUMIF. And when it comes to frequency of values, COUNTIF has you covered.

Have you heard of the mysterious and powerful IF formula? It can turn your spreadsheets into gateways of productivity. And don't forget about the oft-partner ISBLANK(). 

Find step-by-step tutorials for any formula here on Better Sheets. Every formula page comes with links to written blog posts and Better Sheets tutorials featuring the exact formula.

There are no shortcuts to becoming a Google Sheets pro! Learn more here at Better Sheets

Watch the magic for yourself. Video tutorials at every turn here at Better Sheets.

Your spreadsheets will never be the same again.

How To Actually Use SORTN() in Sheets

SORTN(range, [n], [display_ties_mode], [sort_column1, is_ascending1], ...)

Looking for a video tutorial? Members can email me anytime! Check out the blogs below for more info on this formula. Or generate your formula. Find more formulas here at

Learn more about the SORTN() formula:

Using the SORTN Function in Google Sheets

Learn how to use the SORTN function in Google Sheets to sort a range of data and return the top n items from that range. See several step-by-step examples.

Generate a SORTN() 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.