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], ...)

Write a QUERY formula in plain English Say what you want from your data. The free QUERY generator writes the formula, so you can paste it straight into your sheet. Try the free QUERY generator

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.

Watch 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...