I am very happy to share that, new function of Microsoft Excel 365 that is #FILTER, earlier you using Filter Tools from Data Tab, but now its in function.

This function categorised under Lookup & Reference Function in Excel 365, The Filter Function help you to Filter a range of data based on criteria that you want to show.

I really wondered by using this function.
If you want to Know more about it, Watch this video till the end.

Also Watch
Vlookup with Match Function
https://youtu.be/K1ZMmcRFuto

XLOOKUP Function in Excel
https://youtu.be/15ziUhOp-3M

Index+Match Formulas
https://youtu.be/ORn3h4KoNp4

Download Practice File From Here
https://mega.nz/file/JnBT2YDa#VbL5Ae6mSZxSHwxAh3d4AdTKhglE7QkKCYKDT1UtgDI