How to Filter in Excel 

🏫 Learn the fundamentals of Excel in just 2 hours: kevinstratvert.thinkific.com ⏭ Watch next - playlist with all my free tutorial videos on how to use Excel: ru-vid.com/group/PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY

Kevin, I am a consultant to real estate appraisers. This filtering function is just GOLD for them and should save an Everest of time for them! Thank you!

OMG, thanks for making this so simple. I've been using the sort feature for years, but never used filter for some reason. This will make things SO much easier. I love how you make it so simple and clear, thank you!

Thank you Kevin. This has been enormously helpful. I am working on a large spreadsheet as we speak and this video has helped me chop away 95% of the data, leaving the bits I need. Exactly what I wanted.

You just solve a very huge problem for me that would save me hours of working. Do you know that I have been gathering data and working on them for 5 days already? With this filtering it would take at most 1-3 hours total. Great video, thank you so much Kevin. I always enjoy your videos. Thank you for your time I do appreciate it.

I just came to this video hoping for an answer to some problems in excel, but I saw your channel, and know I understand everything a lot more. Thank you Kevin. One more suscriptor

Great tutorial - starting from the simple and moving towards the more complex, all explained in a clear way with good examples. Thank you!

Amazing explanation. I like your explanation especially when you come up with some data and explain the concept using that data.

Thank's Kevin for a great lesson! Greetings, from Latvia!

Thanks, Kevin for the video , it helps me with my first statistics class. They go too fast in school thinking everyone knows this already, refresher tutorials always help.

One more excelent tuturial. Thanks.

Very helpful and I appreciate your cheerfulness. This stuff takes some concentration for us in our 60s!

Hi Kevin, Great video! short and sweet and right to the point. Thank you

I can imagine how much time I have been wasting! Thank you so much for making my work so easy🙏🙏

Kevin..can't thank you enough for the work you have done...one of the best tutorial on the subject ..easy and straight forward with practical examples Keep the good work .

Hi Kevin, great video as always. And there will never be enough Excel videos on your channel! I like the way in which you summarize a potentially much wider subject in a 15-to-20 minute video, getting straight to the content without wasting 1/3 of the video with pointless introductions as many You Tubers do. In the way of requests the list is very long: more multi-media videos, maybe a Photoshop one, now and again a “nerdy” video (what are the basic specs when it comes to replacing my old PC/Laptop...) Thank you again

Thank you, just got a promotion and I need to learn this basic stuff!! You are a lifesaver!

You did an awesome job. Was able to follow you step by step. Was not as scary as I thought it would be. Thank you.

Kevin, great explanation. Thanks!

Thank you so much for this easy to follow video, exactly what I needed to solve a dead end at work :). Have a great day !

Thank for sharing! Insightful!

I love this stuff. Thanks for an amazing RU-vid channel

Always great videos.

Thank You Kevin!!

That was really useful tutorial and helped a lot in saving time. It would be great to have a beginners level tutorial on formulas.Thanks

I like that: Beginner (that’s me) and advanced (hey! I can do that too!) in the same video. And very clear. Thanks

Very good tutorial. Thank you Kevin

This is just what I needed -thank you!

Thank you, Kevin, very helpful!

Thank you! This really saved me! I didn’t realize you needed to set up a table

Thank you! This was very helpful!

you are a natural bro - well done kev

Very helpful! Thanks

This was so easy ! Thank you !!

Again ---> You are the best of the best Again ---> You are the son of technology

So useful! Thank you!

Just what I was looking for. Thanks!!! 😀

Thanks, u have explained in very simple manner!!!

This was so easy ! Thank you !! 👏🏻👏🏻

thanks so much, short and sweet!!!!

Thank you. You have helped me to upgrade my skills with Excel.

We love u yaar....love ur work...love ur representation...

Thank you, I couldn't get it to filter the first way you did it but the second way worked.

thank you so much kevin, this video was very helpful to me and you explains evrything i a very beautiful calm way, thanks again

You are great!! Thank you so much for your helpful videos.

Applying the filter function to my data simplified my tasks. Thank you. Pls produce videos about excel data mining.

Thanks alot, Kevin! I've got an ICT practical tomorrow, and I knew how to make the table but wasn't quite sure about the filtering part :'( You and your video helped alot!!! Thanks!! :D

Great video, thanks for sharing!

Thank you bro-from the Philippines

I'm one of your fan. more videos to come👏

Thanks Kevin. It was a very informative video !!!! Take care & Good Luck .

Brilliant, thank you!

Thank you for all your tutorial videos. I hope you can create a new video tutorial for dashboard and model development. Thank you in advance

I have lab assignment for my data analytics subject. Your video is very helpful 🙏🏼🙏🏼🙏🏼🤍🤍🤍🤍

Just what I was looking 4!

I love you! Keep doing it man

Kevin, I learned things here. thanks

great video as always.

Hi Kevin, THANKYOU so much for the guides. it did improve my work! could you share with us how can we extra info from internet so that it is updated live in excel? for example, share prices, exchange rates or like any figures we can get online

Thank you this really helped

Thanks, this video has been very helpful and will be very useful.

Thanks very helpful and useful

Kevin, Awesome explanation. I finally get filtering now.

You are rocking today, Kevin. Quick Question - Will the filter function work the same way if you filter against consolidated worksheets,i.e. pulling together data from various worksheets into one worksheet or an external workbook?

great Kevin.. got to clean up my dB first then I can do testing ❤

Brill thanks Kevin

Thank you so much

thanks a lot!

Thank youu!!

Wow Kevin, you have a $ multi-million dollar cookie company as a side hustle to your side hustle!! Damn bro!

Hey Kevin, this was very helpful and I wanted to thank you for making this tutorial

Very helpful

Hi Kevin, congratulations on your very informational tutorials in excel and powerpoint. I have a concern in extracting the zonal number only in a irregular patern of complete address text string. I hope you can give me advice. Thanks and God Bless your tutorial endevours 😊

Hi Kevin, lately I have been going through your different videos on Excel tutorial. I just have a doubt here regarding the filter function. We can have headers at the top (beginning of columns). But can we have headers on the left (beginning of rows) and further on set filters based on the left sided headers? I hope you will take some time out to answer this.

Thankyou So much

Very nice

I’d love to learn excel from you. I’ve subscribed so I’ll be looking for your notifications thanks!!!’

Hi Kevin. Is there a way to create a pivot from the filtered list? Specificity when one works with nonnumerical data.

Fantastic. Kevin we love you, we will do click like, write a comments and subscribe every your vodeo becouse you are the best. Thank you and good luck. 😍

Thanks a lot

Hi Kevin, Thank you so much for everything you do. Only one question how I can show the cell (I1) as a dropdown list and keep the same filter function. in the minute 15:16 Thanks again

Great video thanks for making this. I'm new to using Excel. I have a list of 60 names. I need to search and see if all or any of the names appear in other Excel sheets. Can I use the filter feature to do that?

Hi Kelvin, thank you very much for you sharing, may i know is it possible for us to do filtering across worksheet? what i mean is in the same excel workbook, I have created several worksheet, i have added my raw data on one, but hope to do the filtering on another worksheet. thank you!

love your show. can you post how to use data advance filter and short thanks

very good!

Than you so much!!!

Thank you

In your exemple tou used a small table and had some 2, 3 or 4 items as results after filter. Thats easy to count. But in case of massive sheet. Does Excel count the filters results?

Thank you. awesome awesome awesome

Thanks

HI Kevin love your show, can you post something how to use excel DATA Advances

Thanks Awesome feature. Can we filter data with range values full column 1 ....99 rather than single value. The way we use to do in power query...

Great 👍

I am your fan

@KevinStratvert - great video. I'd love to know if there is a way to save views so that I don't have to keep going back to click check boxes. I have some fairly large spreadsheets that I need to be able to view in about 4 different views. I used to be able to use the 'custom view' function but this is greyed out now that I've turned all my data into table. Is there any way to save views of tables (so the table updates rather than having to use the filter function) - I have several conditional formats (to colour cells) set up and these won't come through on filters I don't think (the conditions relate to data that wont be in the filter set). Looking to replicate the 'custom view' function to give me several view I can switch between but using data from a table. Any help greatly appreciated.

@Kevin, I have data in two columns with different count, i want to map column A to column B Example : Column A has value but column B doesn't, In my result, for that row column A should have value and Column B should have blank value, This should be applied to all rows. How can we do this?

Can you do a video on how to copy from a filtered spreadsheet and pasting onto another filtered spreadsheet?

Great video. Thank you for sharing. A question: Can Filter command (in 365) handle wild-cat characters, or is there a way to do it, if we do not know exact values? Thanks,

You are a TERRIFIC Trainer, thanks so much!

Thanks I would like to filter by color however I use the high contrast view with a black background. It's just easier on my eyes as someone who spends many years on the computer. I can't find a way to color boxes in this view