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

[@ArnoVanderNeut-jm6oi]

Life changer for me thnx

[@michaeldingee743]

Thanks for this video. I have this project I'm working on that looks at attendance by Month, Year and Employee. I have created this let formula
=LET(d,Data[ATTENDANCE DATE],e,Data[EMP NAME],p,Data[Position],m,Data[MONTHLY],i,Data[Include],
sl,TRANSPOSE(SORT(UNIQUE(e),,-1)),
vl,SORT(UNIQUE(d),,1), cl,SUM(m),
fr,HSTACK("Start of Month",sl,"Total Payroll"),
sr,HSTACK(vl,SUMIFS(m,d,vl,e,sl),SUMIFS(m,d,vl)),
tr,HSTACK("Total Hours",
SUMIFS(m,e,sl),SUM(cl)),
VSTACK(fr,sr,tr))
I have a column in the Data set called Include =SUBTOTAL(3,[@[EMP NAME]])
Using the Pivotvy function it will filter the Data based on Slicers. The issue is that Pivotby is not available in the Customers current 365 Version.
Theye do have the Filter and Let functions.
How would i add the Filter function into the Let formula above.

[@nadermounir8228]

Thank you for this nice video 📹 👍

[@ExcelSmith]

Thank you. 😀

[@Jojosmith342]

The new Excel version= ? thanks

[@ExcelSmith]

Thanks for the question. The function, LET, works in Excel 2021 and Excel 365. FILTER works in Excel 2021, 365, and 2019.

[@Jojosmith342]

@@ExcelSmith thanks for your quick help

[@yousrymaarouf2931]

Fantastic

[@ExcelSmith]

Thanks. I appreciate it.

[@syedaneesdurez7197]

Amazing

[@ExcelSmith]

Thanks. 😀