Excel Tips - Text Search Box | Dynamic Filtering | One or Multiple Columns

Hey team,

This video will show you how to create a text search box in Excel that can dynamically filter one or multiple columns.

Chapters:
0:00 Introduction
0:34 Getting Started and Single Column Filtering
2:34 Setting Up Multiple Columns

[JeremyWhitehill]

I wished I would have found this sooner. You put in 4 minutes what other are doing in hours. THANK YOU THANK YOU THANK YOU

[bradleybabilino]

Sir I wanted to thank you for this quick and efficient video! I truly appreciate you so much for this!

[SpyroCSagum]

thank you for the video this is very helpful.. if I have many column how to appear the needed columns only?

[billoneil]

Great info. Is there a way to adapt this to be able to searhc multiple columns without having to back out of the original search? Examle: After searching for "Complete" I would like to search for the training module of all that are complet. Thanks

[BadgerWorks]

This worked a treat. However, when I protect the sheet, I can no longer use search. Any ideas how i can secure the sheet, and preserve it's functionality?

[deann]

This is great but any way to have the key word that you are searching, highlight the cell to a color so you can easily see your results when using multiple columns and multiple rows are displaying? I am also going to try and see if I can get the filtering table to filter the table that contains all the data rather than having 2 tables to view.

[richardjullientrip]

This is a great tool.. but I have the problem that it shows: #value!. Where do I go wrong?