Filter Function in Excel - Best Way of Lookup
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
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
Category
📚
Learning