Find Text Instantly with a Custom Search bar


In this Excel Training video, we’re unveiling a secret formula that takes your text search skills to a whole new level. We understand that sometimes, searching for text in Excel can be a bit like finding a needle in a haystack, especially when you only want to focus on specific rows that contain your search phrase. That’s where this ingenious formula comes into play, allowing you to not only locate the desired text but also hide all other rows, providing a clutter-free view of your data.

This technique is particularly valuable for users who want to pinpoint specific information within their Excel files while maintaining a clean and organized workspace. So join us as we show you a formula that can empower you to become an Excel search pro.

PSST, HEY, YOU
(YEAH, YOU!)

Want in on insightful videos, the latest tech developments, and epic exclusive content? Get all this and more as a member of our mailing list.

Resources

Copy and paste this formula:

=IF(SUMPRODUCT(--(ISNUMBER(SEARCH($F$1, A2:B2)))), 1, 0)

John Gleave

John Gleave has been a researcher, content writer, and senior editor at Business Tech Planet since 2022. John was formerly a data analyst and web designer with expertise in several programming languages, such as JavaScript, JQuery, PHP, CSS, SQL, and more! With a passion for writing and technology, he has now focused his skills on crafting tech guides for BTP. You can connect with John on LinkedIn.

Recent Posts