Filter Functions in Google Sheets - FILTER, SORT, SORTN and UNIQUE
Sheets offers functions for sorting and filtering data that are typically only found in the menu options of other spreadsheet programs, or not found at all in the cases ofSORTNandUNIQUE. On the desktop version of Sheets, theSORTandFILTERfunctions 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.
All filter functions
The ability to use these as functions is what sets Sheets apart from the competition.
Videos for each filter function