Use Excel’s FILTER and LET Functions to Show Rows with Blank Cells

Описание: The newer versions of Excel have introduced some powerful new functions. Two of my favorites are FILTER and LET. In this video, we combine these two functions to build an equation that uses multiple criteria to filter a report.

The equation checks for cells containing blank values in one of the columns. It then shows only the results that are within a given date range. In addition to building the equation, we look at how to separate long equations onto multiple lines in the formula bar to improve readability.

Thanks for watching.


🎬 YOUTUBE LINKS 🎬
————————————
Work Faster in Excel with These 10 Essential Keyboard Shortcuts:    • Work Faster in Excel with These 10 Essenti...  

How to Use Excel’s FILTER Function…In Three Minutes:    • How to Use Excel’s FILTER Function…In Thre...  


⏱ TIMESTAMPS ⏱
————————————
0:00 Introduction
0:36 Outline
0:59 Filter Blank Cells
2:48 Filter Date Range
5:09 Update Formatting with LET
8:33 Wrap Up