Better Sheets

How to Use SORTN() in Google Sheets

Description

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

How To Actually Use SORTN() in Sheets

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

Try SORTN yourself

Use the range A1:A10 to return the first 5 unique values sorted in ascending order. Your formula should only include the necessary arguments to achieve this.

Your formula

Hints (3)

Locale Separator ,

Official Docs

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 BetterSheets.co/formulas

Transcript-matched member videos for SORTN(). Click through to watch.

Browse more tutorials

Calculate ROAS in Google Sheets

Calculate Return on Ad Spend with a formula combination. Bonus: create a...

Intermediate

CONCATENATE() ROUND()

Hardest Formula: SumIF | Addition Based on Dates / Values

Demystifying the SumIF Formula. Add up your values based on a condition,...

SUMIF() UNIQUE()

Tic Tac Toe In A Google Sheet

Figure out who won a game of tic tac toe. inside a Google Sheet. Great f...

AND() COUNTA() FILTER() IF() IFERROR() +4 more

Create a Trello Board with Transpose Formula in Google Sheets

Use Transpose() to create a web-based, Kanban style, list-making applica...