Create a Dynamic Search Box in Excel to Find Anything within your Data!

In this video, I will show you a step-by-step guide how to create a Dynamic Search box to find anything within your Database in Excel.
Microsoft Excel is so versatile for analysing Data and it has a lot of functions that can help you stay productive at your workplace or business.

But, how do you search for Data within thousands of rows in one second?

In this video, I will show you how to stop the endless scrolling across columns and down the rows in Excel by creating a dynamic Search box that displays data as you type.

-This tutorial will also explain functions like FILTER, ISNUMBER and SEARCH functions in Excel.
- How to Insert and format Shapes and Stock images in Excel

- Conditional Formatting in Excel

🔽 CONNECT WITH ME

🔔 SUBSCRIBE ON YOUTUBE

#microsoftexcel #filterfunction #isnumber #searchfunction

[ruthkingsley]

Hello everyone,
If the FILTER function is not working on your Excel version, please watch this video and upgrade to the latest version with newer functions

[AbdoKassabji]

Thank you Ruth, this worked for me but in the same sheet, when I try it in a single different sheet It gives me "0" in the cell where I write the formula

[GuidoBusuttil-hh]

Thank you Ruth. I have used your tutorial for my search function. not sure how to secure the search sheet that the formula is not tamered with and so too for the columns i have of hyperlinks. could you advise?

[azeezwahab]

I am glad I came across this. Pls how can I be versatile in excel and data analysis.

[RajendraRout-qf]

Maam, please make a video using sumifs+xlookup+conditional formatting together in a table data

[adgaliart]

Thanks Ruth, would you mind sharing the file dor better practice?

[piokany]

Thank you, very helpful.I will also get a heart please, please, please.

[paulschultz]

When you were creating a tutorial you should zoom in on the table so that the viewer can see the data information more clearly. I am trying to view on my cell phone but it is very very difficult to see the small information on the screen.

[ChriciousChongo]

Hi Ruth, great teaching. Can this also work in MS Office 2013?

[mostainbillah]

Dear mam thank you for your tutorial, it is amazing and incredible video tutorial for excel learners,
Mam I have need a code for searching another workbook data into active worksheet,
Could you please modify your Code, for me to get data from master workbook, I am waiting for your support, please help me

[DanielOnyedikachiOkwandu-re]

Thanks very much Ruth
Please can this trick work in 2016 version?

[daXcel]

Thanks for the video. Could you kindly tell me the name of the mic you use to record the videos?

[PichpisethNou]

Hi, I had problem with this search bar as we share this excel file on server with my college.

When they tried to search, it show error. Could you share me how to fix this?

[bm-hbhpii]

Unless if you are using office 365 or latest version of office 2021, its useless to use Filter formla for old version of office

[ernestlorenzoursua]

Good Day.what excel version do you use? Thanks

[bisht_]

Hi! I don’t have the Filter function in my Excel. Is there any other syntax for this?

[Shng]

Thank you so much for your excellent explanation. I find that your explanation is a bit slow to fully understand.

[usmaniqbal]

Perfect Mdm please also share data file for better practice..

[alansherzad]

Hello after this operation is done can we add more name and information?

[kardiiobi]

Great vlog sis thank you please I would love know how you record your video when you are working on your excel this is cause I want to create content for my LinkedIn please wat too did you use to make this recording I tried using screen record it was hanging my laptop