Real-Time Data Search Box in Excel with FILTER function [Part 1]

Dynamic Data Search Box in Excel with FILTER function [Part 1]

In this tutorial you will learn how to create a dynamic data search box in Excel that allows you to filter your data in real-time as you type. 
It covers the basics about the FILTER function, multiple different search modes, and how to create dynamic search box from scratch and connect it to the FILTER function.

00:00 Introduction
01:16 Dynamic search box from scratch
05:00 Advanced search mode “Partial Match”
08:27 Advanced search mode “Partial Left Match”
12:55 Dropdown selection for search mode

This tutorial requires the latest Excel version (Excel in Microsoft 365).

🔎 EXCEL FUNCTIONS COVERED IN THIS TUTORIAL

- FILTER Function
- ISNUMBER Function
- SEARCH Function
- LEFT Function
- IFS Function

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

You want to show your support and help me grow?
Here is what you can do.

☕ WANT TO MAKE MY DAY?

🔥 MORE AWESOME EXCEL AND POWERPOINT CONTENT

Note: Some of the links in this description are affiliate links, meaning, at no additional cost to you, we will earn a commission if you click through and make a purchase. This supports the channel and allows us to continue to produce videos like this. Thank you for your support!

#excel #searchbox #filter

[Suzukii-DIY]

Please include in your title that this is for Office 365 only. I just wasted 35 minutes I can't get back only to find what other commenters found out based on your response, that this is only for 365 Users. Kudos to you however for the 365 Office App and this tutorial. You still get a thumbs up from me. Now I need to find out how to do this in MS Office 2019.

[misscall]

This video was just too perfect and detailed! Well done Sir! Just what I had needed!

[SizzytopCA]

Easily some of the best excel tutorials out there.

[halukakalin]

This is the best and complete tutorial I have ever seen, thanks.

[randomite]

Great tutorial! Notes to myself, this part 1 tutorial doesn't convert source data into table yet (which part 2 does). So this tutorial works with absolute cells at this point.

[MrAimalsultani]

Well-Done Man, thanks for sharing the wonderful Ms Excel tutorial.

[lmajiedmary]

Glad I found you!! Thank you, thank you, thank you for this tutorial!! I have been searching for something like this for two days!!!

[francescpaurebull]

A really good solution to my needs. I've seen it after searching a lot and it's great. Thank you very much.

[patrickschardt]

Great stuff. Amazing tutorial.

The two things I would do differently are:
1. Put the IFS function in the INCLUDE argument since the only thing changing is the search mode formulas.
2. Use SWITCH instead of IFS since your IFS conditions checks the same cell (for different things).

And now with the edition of LET and LAMBDA, I’d probably incorporate those too

[SilvestreECamposano]

Wow!.... The best explanation... Thank you very much for the knowledge gained.... More power..

[ShiroZayas]

Thank you so much!!! Great tutorial!!!

[Sammy-xvmq]

Tried all 3 formula work perfectly fine
Thank you 🙏

[truthmediamunawar]

4:32 I used this for my requirement tracker thanks dude

[Fredick.]

Realmente muy interesante, en este momento lo pondré en práctica. Gracias por el aporte.

[nickhorrific]

you should re-post this, incredibly useful

[pstradeandsuccess]

There is no Formula named FILTER in Excel, It Has FILTERXML only .. Which Version of Excel to be used ?

[mannydelapena]

The best of the best. Very clear and simple to follow. Amazing guys. Thank you very much.

[rafital]

Really good and clear tutorial, thank you

[ameralrowwad]

Well done, i follow your video and its amazing, thanks alot for this information and sharing 👍

[effconinternational]

Excellent Presentation and very useful video. Thanks.