FILTER Function

In this video we look at the FILTER function as well as filtering data “manually”. We’ll also use a very helpful Formula that includes The SORT function and using cell references to build a basic dynamic report based on multiple criteria! -- Current Section: ➡️Section 6: Functions https://docs.google.com/spreadsheets/d/1yXw6KFj5JrPHBuAHHpHzSB4JZfvhxcJ6KEBsUiHTL5Y/copy Previous Sections: ✅Section 1: Organization https://docs.google.com/spreadsheets/d/1SbRW5LJS5P1A5ZA1hxZv3Hnv3bos-dl-e0F96KCuLrA/copy ✅Section 2: Formula Building https://docs.google.com/spreadsheets/d/1nQF5cN3F_QienoZ2hK87L_xoC0Rc8apNrm7PVA5LaHo/copy ✅Section 3: Data Validation https://docs.google.com/spreadsheets/d/1kA9gqFX1d-tAA-y6vWUHAtS9xglwCOAx2XuHodrkkJc/copy ✅Section 4: Sharing https://docs.google.com/spreadsheets/d/1cqc0-arYUW-lLGnhkr4mrcwarRupyavHjJ4c6RmDfCE /copy ✅Section 5: Numbers https://docs.google.com/spreadsheets/d/1FsoYxdQImDyBMHcqtqw0NBhQbQcPNyg67tXYd8qw0gs/copy -- 🗣️Socials: WEBSITE: https://matttechtidbits.github.io/matttechtidbits/ REDDIT: https://www.reddit.com/user/MattTechTidbits LINKEDIN: https://www.linkedin.com/in/matthew-klemme-ba9126b2?trk=pub-pbmap INSTAGRAM: https://www.instagram.com/matttechtidbits/ Need a Freelancer? Check out my Upwork Profile: https://www.upwork.com/freelancers/~01e15eefe1443fcea1 – ⏳Timestamps: (00:00) Introduction (00:41) Filtering a Structured Table (01:15) FILTER() Function and Syntax (03:43) Mismatched FILTER() Conditions Error (04:09) Including Top Row With Structured Tables (05:41) Adding Additional Conditions (08:22) Dynamic With New Data Added (09:15) Using FILTER() with SORT() (10:06) Conclusions (10:29) End Slides LINK 01:50 structured table 4:22 New Table Footers 🎵Music is "WFH" made by me with my solo music project name, @ambiosynthesis https://www.youtube.com/watch?v=sKi5cGTQoBM — Tags: #googlesheets #spreadsheet #technology #sheets