Cómo hacer un BUSCADOR DINÁMICO E INTELIGENTE en Excel 🔍 (SIN MACROS, SIN VBA)

Search as you type. In this video, I'll show you how to create a dynamic and intelligent search engine in Excel without using macros or VBA. We'll do this with a powerful formula and a text box. Searches can be multi-criteria and in the columns we specify. These searches can be updated automatically, meaning they'll appear automatically if we add new records. We can also highlight search matches with conditional formatting. The topics you'll cover: ✔️00:00 Introduction to the search engine ✔️03:26 Inserting a text box ✔️04:28 Linking a text box to a cell (LinkedCell) ✔️05:39 Searching with the Filter function ✔️11:13 Find function to find a match ✔️13:19 IsNumber function to convert between True and False ✔️16:07 Applying conditional formatting ✔️19:44 Styling our search bar VISIT OUR WEBSITES: 🔵 https://www.eltiotech.com 🔵 https://www.tiotech.net 📩 Join Telegram: https://t.me/eltiotech 📒 Join WhatsApp: https://whatsapp.com/channel/0029VaEa... FOLLOW US ON OUR SOCIAL MEDIA 🔴 TikTok:   / eltiotech_   🔴 Instagram:   / luismiguelvelavela   🔴   / eltiotechoficial