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 - sheetshelp.com/query/ QUERY Video -    • QUERY Function in Google Sheets - Bas...   FILTER - sheetshelp.com/filter/ SORT - sheetshelp.com/sort/ SORTN - sheetshelp.com/sortn/ UNIQUE - sheetshelp.com/unique/ Template - 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! twitter.com/josephkaptur/status/147707250173361766… #query #googlesheets #spreadsheet

• #science_technology
• #query
• #filter
• #unique
• #sort
• #sortn
• #array
• #google_sheets
• #spreadsheet
• #remove_duplicates