Deprecated: Creation of dynamic property ternplugin\youtube_video::$post is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/automatic-video-posts/vendor/ternstyle/plugin/src/class/youtube_video.php on line 64

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

Posted on by Annie D

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

Further Help

I offer limited consulting services to potentially assist you with data challenges, whether it's designing a complex Excel formula, writing a macro or building a whole new process for data capture, modeling and analysis.  Contact me if you have a need.

ExcelIsFunTue, September 7, 2021 7:45pm