El filtro de Excel que parece imposible (y es muy fácil de crear)

🔥 Check out all my courses 👉 https://www.deztaca.com/cursos Does your Excel spreadsheet fall short when you need to quickly find something among hundreds of rows, forcing you to resort to Ctrl+F or manual scrolling? In this video, you'll create a smart search tool in Excel: filter by list, by another list, and also by free text that's filtered as you type. It's all dynamic, all in real time, without needing to click any buttons. 🎁 Download the example file: https://www.exceleinfo.com/buscar-int... This isn't your typical table filter. It's a combination of validation lists, an ActiveX control, and a formula using FILTER that most people aren't familiar with, because FILTER usually only returns results when you already have a defined value. Here, you'll solve that problem with a clever trick. You will learn to: Create validation lists connected to your table Insert a text box using an ActiveX control Write a macro that connects the TextBox to a cell in real time Build a FILTER formula that combines lists and text using + and * Use ISNUMBER and FIND to perform an approximate search by name Test the search by filtering by one, two, or all three criteria simultaneously The ISNUMBER + FIND part is often poorly explained, and it's precisely what makes your search function work like a real database search. Did you know you can combine FILTER with a partial text search? 📌 Video Chapters 00:00 The Add-in That Gives Excel Superpowers | EXCELeINFO add-in 00:48 Automatically save each Excel sheet as a PDF 02:17 Separate compound first and last names in Excel 05:25 Convert text dates to actual dates in Excel 08:17 Generate test data in Excel (sales, finance, HR, inventory, logistics) 10:44 Automatic backup of the active Excel file 13:11 Convert numbers to words in Excel (for invoices) 16:56 Error auditing in Excel: find all cells with errors 18:34 How to check for EXCELeINFO add-in updates 19:40 Download the EXCELeINFO add-in for Excel for free 20:41 Excel courses and training for businesses -------------------------------------------------------------------------------------------------------------------- ► Get certified in Excel | https://www.exceleinfo.com/certificac... ► Download the EXCELeINFO add-in for free | https://addin.exceleinfo.com -------------------------------------------------------------------------------------------------------------------- 👉 FOLLOW ME ON ALL SOCIAL MEDIA About Me | https://sergioalejandrocampos.com My Course Academy | https://www.deztaca.com Blog | https://www.exceleinfo.com Facebook |   / exceleinfo   Instagram |   / sergioacamposh   LinkedIn |   / sergioacamposh   WhatsApp | https://whatsapp.com/channel/0029VaET... Telegram | https://t.me/EXCELeINFO TikTok |   / sergioacamposh   X | https://x.com/SergioACamposH #Excel