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 - [ Ссылка ]
QUERY Video - [ Ссылка ]
FILTER - [ Ссылка ]
SORT - [ Ссылка ]
SORTN - [ Ссылка ]
UNIQUE - [ Ссылка ]
Template - [ Ссылка ]
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!
[ Ссылка ]
#query #googlesheets #spreadsheet
