Filter Functions – FILTER, SORT, SORTN, and UNIQUE

by

Sheets offers functions for sorting and filtering data. On the desktop version of Sheets, the SORT and FILTER functions are available through the menus as shown in the pictures below, while the tablet version has a ‘Create a filter’ option in the more (three circles in a vertical line) menu on the right-hand side of the screen.

Filter button on the desktop toolbar

Filter button on the desktop toolbar

SORT options in the desktop menus

Sort options in the desktop menus

The UNIQUE function removes duplicate rows of data in a spreadsheet. The SORTN function returns n number of items from a range of data.

If you are nesting these functions to use abilities from more than one, you may want to use the more flexible QUERY function instead. It brings the power of SQL queries into spreadsheet functions.

All Filter Functions

Sort Options
SORT function
FILTER Options

FILTER Function

Screen capture of the unique function

UNIQUE function

Screen capture of the SORTN function

SORTN function

Video Tutorials

Thumbnail showing screen shot of FILTER video tutorial
FILTER Function
Thumbnail showing screen shot of UNIQUE function
UNIQUE Function
Thumbnail showing screen shot of SORT function
SORT Function
Thumbnail showing screen shot of SORTN
SORTN Function

Leave a Comment