Google Sheets - Comparing QUERY to "Regular" Functions like FILTER, SORT, UNIQUE and SORTN

The family of filter functions in Google Sheets all output an array of data. The QUERY function also outputs an array, but in a different way. We will go through several examples to illustrate the differences to help you choose which will work best for you.

QUERY Page - https://sheetshelp.com/query/
QUERY Video -    • QUERY Function in Google Sheets - Bas...  
FILTER - https://sheetshelp.com/filter/
SORT - https://sheetshelp.com/sort/
SORTN - https://sheetshelp.com/sortn/
UNIQUE - https://sheetshelp.com/unique/
Template - https://bit.ly/queryvfilter

Timestamps:
0:00 Intro
0:28 Simple sort
4:11 Matching certain words
7:06 Less than a calculated amount
10:04 Add a labeled, calculated field
13:51 Add a filter to a labeled, calculated field
17:08 Sort and limit
20:25 BONUS - Remove duplicates
24:28 Next video - Excel vs Google Sheets Pivot Tables


I asked about the error at timestamp 23:46 on Twitter and @josephkaptur thinks it is caused by using the Remove duplicates tool on dynamic data. Therefore, it removes the duplicates, but they are created again by the underlying function. I bet he's right. Thanks!
https://twitter.com/josephkaptur/stat...

#query #googlesheets #spreadsheet