Wyszukiwarka danych bez VBA czyli funkcja FILTRUJ w akcji. Funkcja FILTRUJ i wyszukiwarka danych

#excel #exceltutorial #exceltricks Watching the video will teach you how to create a data search engine without using VBA in Excel. The Developer tab allows you to use ActiveX controls, such as Text Boxes and Combo Boxes (drop-down lists), which will be responsible for searching data. The data will then be filtered using the FILTER() function, which will filter data from the table (object/mechanism) in various ways, such as searching for data that contains the search text or begins with the text you entered. The video will also define appropriate names for ranges so that they can be used in formulas. To enhance the visual appeal of our search engine, we will also use several shapes and search icons (magnifying glass). JOIN US FOR COFFEE! If you liked the video and found it valuable, you can buy me a coffee :) https://buycoffee.to/smartexcel ======================== And now for some links :) Link to my online courses: https://smartexcel.pl/lista-kursow/ #helion #videopoint Importantly, you'll find my latest project there: the video course "Excel in HR. From Theory to Practice," which I created in collaboration with HELION Publishing House. ========================== Link to the "knowledge for pennies" subpage, where you'll find various and practical materials: https://smartexcel.pl/wiedza-za-grosze/ ======================== Best regards, and as always, happy EXCELing :)