SORTN()

Description

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

How To Use in Sheets

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

External Links

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.

0Better Sheets Tutorials

No videos yet. Stay tuned!