Filter by rows and columns: Excel Formula for Any Version of Excel! Excel Magic Trick 1752

Download Excel File: https://excelisfun.net/files/EMT1752.xlsx
Learn how to filter a data set by rows and column and extract the data of to the side. See the Microsoft 365 Excel solution using the FILTER function. Then see a solution that works in any version of Excel with Advanced Filter and the AND function!
1. (00:00) Introduction to problem at hand
2. (00:59)Microsoft 365 solution using: FILTER, SEARCH, XMATCH and ISNUMBER functions
3. (05:46)Any version of Excel solution using: Advanced Filter and the AND, SEARCH and ISNUMBER functions.
4. (08:37) Conclusion and call for viewers to comment and tell us which one you like!!
5. (08:53) Closing Video Links

Видео Filter by rows and columns: Excel Formula for Any Version of Excel! Excel Magic Trick 1752 канала ExcelIsFun