Build a search box in Excel to find anything in your dataset.
Check out our Excel course!: [ Ссылка ]

🆓 DOWNLOAD Free Excel file for this video: [ Ссылка ]

In this video, we'll make a dynamic search bar so you can search for any values in your dataset. We will start creating a search box with the developer button. Then, we'll use the filter formula to look for values in a dataset. Following this, to get a partial match, we'll combine the isnumber and search functions to the filter function. Then we'll add all of the other columns we want to search by. Finally, we'll design the search bar with icons, shapes, and conditional formatting so the matching values stand out.

LEARN:
🔥Power BI for Business Analytics: [ Ссылка ]
📈 The Complete Finance & Valuation Course: [ Ссылка ]
👉 Excel for Business & Finance Course: [ Ссылка ]
🚀 All our courses: [ Ссылка ]

SOCIALS:
📸 Instagram - [ Ссылка ]
🤳 TikTok - [ Ссылка ]
🧑‍💻 LinkedIn - [ Ссылка ]

▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬

Chapters:
0:00​ -​ Search Bar with Exact Match Only
2:55​ - Adding Both Partial & Exact Match
5:36​ - Adding all columns to the Search Bar
6:58​ - Search Bar Design
9:36​ - Bonus Trick!

Disclaimer: I may receive a small commission on some of the links provided at no extra cost to you.

свернуть