SORTN practice

SORTN returns the first n rows of a range after sorting it, in Google Sheets. Below are the 1 Google Sheets exercise on Sheetsdrill that use it, each checked instantly in your browser.

Syntax

SORTN(range, [n], [display_ties_mode], [sort_column], [is_ascending])

What people get wrong

SORTN is the one-function way to get the top three deals.

Google Sheets exercise that use SORTN

• Top three deals with SORTNLevel 4Pro

Often used together with: SUM