Create Dynamic Excel Filter - Extract data as you type

Рет қаралды 625,204

Күн бұрын

In this excel tutorial video, learn how to create a DYNAMIC EXCEL FILTER - which extracts data as you type.
Download file here: trumpexcel.com/dynamic-excel-...
This dynamic Excel filter allows you to type the filter text in a text box and instantly extracts the records as you type in the search bar.
While Excel already has a filter and advanced filter functionalities, these are not dynamic. This means that you will have to specify the criteria and filter, and then change the criteria and filter again.
This dynamic Excel filter, on the other hand, filters the data as soon as you change the text in the search box.
This Dynamic Excel filter can be created in 3 steps:
-- Getting a unique list of items (countries in this case). This would be used in creating the drop-down list.
-- Creating the search box. Here I have used a Combo Box (ActiveX Control).
-- Setting the Data. Here I would use three helper columns with formulas to extract the matching data.
00:00 Intro
00:10 Demo of the Dynamic Filter Box in Excel
01:12 Creating a Unique List of Items
02:20 Creating the Named Range
03:17 Creating the Filter Combo Box
05:00 Adding the Helper Columns
08:47 Extracting the Data By Typing in the Filter Combo Box
You can use this dynamic Excel filter when you have a huge dataset and you want to quickly filter it by entering the text. Since this is dynamic, you can remove the existing filter by simply deleting the text in the text box and type something else to filter based on it.
While this advanced dynamic Excel filter works great with a small dataset, you may find that it tends to get a bit slow when you have large data sets. This is because it uses formulas and helper columns which can lead to slow processing time and data analysis.
Step-by-step written tutorial and download file:
trumpexcel.com/dynamic-excel-...
You May Also Like the following Tutorials:
-- Creating a drop-down list in Excel: • Creating an Excel Drop...
-- Advanced Filter in Excel: • Advanced Filter in Exc...
Also, I have made all of my Excel courses available for FREE. You can check these out using the below links:
✅ Free Excel Course (Basic to Advanced) - trumpexcel.com/learn-excel/
✅ Free Dashboard Course - bit.ly/free-excel-dashboard-c...
✅ Free VBA course - bit.ly/excel-vba-course
✅ Free Power Query Course - bit.ly/power-query-course
#Excel #ExcelTips #ExcelTutorial

Пікірлер: 388

@smartshan4u 4 жыл бұрын

Thank you very much for sharing this video

@Rais1959 3 жыл бұрын

VERY COMPLICATED METHOD

@TheEngineerbasel 4 жыл бұрын

Thanks, It was very very vey very helpful

@paulord603 6 ай бұрын

This was brilliant. Thank you for sharing.

@seoklee8 2 жыл бұрын

Very clear explanation

@nikunjpatel4142 4 жыл бұрын

Awesome Trick instead of making so much combination of formulas

@asifkhurshid9208 3 жыл бұрын

Excellent demo...Thanks and kind regard.

@furaosentu 2 жыл бұрын

5:24 OCD trigger. Apart from that, great method and great video.

@rizwanaslam5131 8 жыл бұрын

WONDER FUL EFFORT BY TRUMP EXCEL.KEEP IT UP NEED SOME MORE DEMOS

@M0RpH3dSaTaN 10 ай бұрын

Wonderfully Done, Cheers mate!

@TheSingularitarian 3 жыл бұрын

This is elegant.

@jubileelifeinsurance5991 4 жыл бұрын

Respected Sir, You are gr8

@jayakrishnankrishnan7092 5 жыл бұрын

Easy understanding

@prakashsrinivasan7840 Жыл бұрын

Terrific video Sir Thanks for sharing 👍😀

@Avibad4u 5 жыл бұрын

Nice video. Lots of things to learn

@shreyakpatil5797 Жыл бұрын

Thanks a lot , exactly what i need.

@kudykhovillareal1500 4 жыл бұрын

Thank you sir you make my job Compatible!!!!!!!!

@aealex5589 4 жыл бұрын

all the videos are very useful thank you so much

@storekeeperTips 3 жыл бұрын

Excellent explanation sir

@PutriCandra 2 жыл бұрын

Thanks for sharing!

@sasavienne 5 жыл бұрын

A great video. 🌟 🌟 🌟 🌟 Thanks a lot.

@HaiNguyen-vu9cj 5 жыл бұрын

Thank you very much.

@ajaykumarsahoo1669 5 жыл бұрын

Very helpful

@petralabui9302 Жыл бұрын

Brilliant 👍👏

@freezendog7 3 жыл бұрын

That's amazing!!! Thanks!!!

@ahmadaltayeb1983 2 жыл бұрын

Great tutorial

@rajadey1552 2 жыл бұрын

I have to say is awesome 😯 ❤️

@hlahlajubase402 6 жыл бұрын

very useful thank you

@manuele1900 3 жыл бұрын

You're great!

@omersar4221 5 жыл бұрын

IT İS GREAT TUTORİAL

@chocaletyboy88 4 жыл бұрын

Thank you so much

@CHANDRAVEER09 3 жыл бұрын

You are awesome bro

@nazeemnajmu8077 4 жыл бұрын

You are awesome

@muhammadsidik4744 3 жыл бұрын

thank you. I will try this

@ducanhvu9658 5 жыл бұрын

Thank you

@thebesttechnical3608 5 жыл бұрын

Awesome Video

@allanquezon6841 8 жыл бұрын

Big help thanks

@sushantachoudhury7021 3 жыл бұрын

superb...

@samyphy6 4 жыл бұрын

THANK YOU A LOTTT..... THIS VIDEO HELPED ME AT RIGHT TIME....VERY NICE

@trumpexcel 4 жыл бұрын

Glad you found the video useful!

@ThomasTim 6 жыл бұрын

Very good video

@NemanjaGavrilovic 5 жыл бұрын

SUPERB!

@abbaslokhandwala8445 3 жыл бұрын

It's awesome, now we have new formula to filter the same but that's just for Office 365 users.

@ToughdataTiktok 4 жыл бұрын

bless up

@zakeerrg3010 Жыл бұрын

I love the way you explain every detail, with definitive pronunciation and clarity. Keep up your good work.

@vbfpaul9295 5 жыл бұрын

Thats great....

@enesnature5486 4 жыл бұрын

amazing

@andrewstevenson5449 4 жыл бұрын

Excellent clear summary of how to solve a tricky issue.

@TheKt75 4 жыл бұрын

Pressure cooker- 3 whistles. Lunch is ready. Great video.

@trumpexcel 3 жыл бұрын

If you found this video useful, please give it a thumbs up 👍 and subscribe to the channel. Also, let me know what Excel topics you want me to cover in future videos. Here are some other Excel tips videos you may find useful: ✅ Filter data as you type (using FILTER Function or VBA): kzfaq.info/get/bejne/rqiCnqanm7i7k3k.html ✅ Advanced Filter in Excel: kzfaq.info/get/bejne/kLt2eNSbqbKxYn0.html Also, I have made all of my Excel courses available for free. You can check these out using the below links: ✅ Free Excel Course (Basic to Advanced) - trumpexcel.com/learn-excel/ ✅ Free Dashboard Course - bit.ly/free-excel-dashboard-course ✅ Free VBA course - bit.ly/excel-vba-course ✅ Free Power Query Course - bit.ly/power-query-course

@learnapplyamplify5826 4 жыл бұрын

That was clear & preciously described

@RavindraSingh-qu9ye 3 жыл бұрын

SUPERB

@littlelionmanOO 2 жыл бұрын

After watching a few other videos, this one is the best ! thank you!

@kennahnakez3402 5 жыл бұрын

Awesome

@steveUTsteve Жыл бұрын

Amazing functionality. The presenter goes a little fast, but of course we can stop and replay.

@chuzi_shopr Жыл бұрын

Thank you for a very clear instruction on how to do each step. :)

@AlexaGTV 3 жыл бұрын

I am creating a new database/housing system for my position and have been SEARCHING for something that would let me filter easier with numerical data and text data. This is the best solution I've found and you made it so easy to follow and do. Thank you so much

@sunilvetri2716 2 жыл бұрын

I'm The luckiest person I think about it past 3 days finally I found it and u perfectly nailed it.

@June25th87 4 жыл бұрын

I've been watching many video about this trick, but your formulas is the best and most applicable. Thank you!

@juanmanuelprat5490 8 жыл бұрын

This was a life saver for me. Very clear and quick. Straight to the point. I used a helper pivot table and an slicer to pick the "unique value" from the list, so it was exactly what I was looking for. Thanks a lot!

@boehringervietnam2676 4 жыл бұрын

Such a great demo and clear explanation.

@islamic31399 2 жыл бұрын

Great

@leshecclaassens3740 4 жыл бұрын

Great tutorial. Based on this tutorial I manage to get my own version up and running. Also learnt a lot in the process; much appreciated.

@suhelquadri889 9 жыл бұрын

Excellent--..and amezing way of teaching...Thanks Sirji...

@Nguyenhongduc1972 8 жыл бұрын

Like youre accent

@ashokanselliah9571 4 жыл бұрын

Excellent video presentation. Hugely helpful Sir, Many many thanks for this..

@ritchicaca 8 жыл бұрын

Trump Excel, you are a genius! This is great! Good job! Very helpful!!!

@RiteshParakkal 8 жыл бұрын

Excellent Function. Many Many Thanks

@kmcdermott69 4 жыл бұрын

You just made my life much easier - thank you!

@coachz7970 9 жыл бұрын

Great and easy way of explaining the topic, thank you very much.

@anirudhjayant9557 7 жыл бұрын

Thanks a lot, man! You have saved my developer's time. I highly recommend this to anyone who is looking for any search functionality in excel.

@JustinStrigl Жыл бұрын

Thank you very much, I only found problems using the "search" function but I replaced it with "vlookup"

@sharma9277 3 жыл бұрын

Advance filter with macro is easy

@dudukusudhakar2903 8 жыл бұрын

sir, your way of presentation is excellent and simply undestanble.

@AJJmusician 7 жыл бұрын

BRILLIANT!!!! Thanks a million for this!

@indianprofiles 5 жыл бұрын

Garda uda diye ho bhai...Gazab 👌👌👍👍

@saleemjawed7137 5 жыл бұрын

Outclass mind blowing

@cstkl1 5 жыл бұрын

nice

@TheOndricek 8 жыл бұрын

This is terrific! And I saw in one of the comments below that you can do this for two columns at the same time - amazing! Thank you for sharing!

@srvithal38 5 жыл бұрын

Thank you..Thank you ..Thank you veryyyyyy much brother. You have explained crisp and clear. Very useful knowledge sharing. It helped me very much

@jaymungur8616 5 жыл бұрын

Hello bro...am doing a similar task..but cannot do it...please can u help..I will send u the worksheet...plz

@ambadas.kulkarni2021 5 жыл бұрын

Thank you very much for sharing ... Very nice teaching ..

@jeanielee7980 6 жыл бұрын

thank you! this was very easy to follow and helpful!

@DVSgolddust 5 жыл бұрын

Thank you For your help. This made my Stockhandling database very complete on an easy way.

@andrewo6521 4 жыл бұрын

Thank you - I work on an IT desk and we use this to associate keywords to specific departments. Works brilliantly! It can be tricky when if the user (me) makes a tiny error after inital set up but it's worth the time taken to set up

@trumpexcel 4 жыл бұрын

Glad it helped :)

@ZAHIDHUSSAIN-ri5kg 4 жыл бұрын

What a Magic. Thank you Sumit

@sikhosikhaobyyogesh8070 Жыл бұрын

Wah 🙏

@bassamthebian9461 2 жыл бұрын

Thank you, just what I was looking for, it helped me great.

@IonbeamGreg 6 жыл бұрын

Very interisting usage of different formulas - Dynamic w/o VBA ! Great !

@bellostephen6791 5 жыл бұрын

You rock, man! You're the best! Been searching for how to do this for several hours...You made it simple!!!

@sglander2 5 жыл бұрын

This is awesome! I used it to make an incredible daily job cost report. Thank you!

@educacionportable 5 жыл бұрын

Excellent tutorial Thank you so much God bless you. Best regards from Nicaragua.

@gm2023MJ 2 жыл бұрын

Very informative and useful. Your step by step instructions is a great help to a layperson. Wonderful tips to help in retrieving information. Thank You Sumit.