AI Hub / AI posts
AI · 1 min read

SORTN

SORTN function in Google Sheets: Returns the first n items after sorting.

November 5, 2026
Google Sheets functions / Filter
Filter function · Google Sheets

SORTN function

Returns the first n items after sorting.

Availability

PlatformStatus
ExcelNot listed
Google SheetsListed
On Excel: use TAKE. Combine TAKE and SORT, as in =TAKE(SORT(range,2,-1),5).
Reference entry. Syntax, tested examples and a practice file arrive with the full guide. Open the official function list.