 # How To Use SORTN()

Description

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.

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.

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

How To Actually Use SORTN() in Sheets

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

0Better Sheets Tutorials

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

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.

Better Sheets