Excel 2013 Advanced Filter using a Macro

Tutorial for Excel 2013 to create an advanced filter and then adds macros to run and clear the filter and attaches them to buttons

[@qthaisdeyy]

Hands down tNice tutorials is one of the best tutorials I've seen on any subject, ever! Clear, concise and incredibly informative and easy to follow.

[@EKR8]

I’ve been searching for ages on how to do this and finally this is a straightforward tutorial to follow, thanks.

[@loreewagy]

This tutorial was GREAT!!! Thank you. I was able to replicate it to many of my lists and they worked! Very GRATEFUL!!

[@kuurukorp2441]

Thanks Rick! I always wanted to build a macro, but hated the idea of reading the instructions. Then I realized there might be a macro instructions on specific macro I was looking for, and this was it. Man! easy to follow and spent 20 minutes building your macro on my spreadsheet that I could use. Great JOB!!

[@SaidElnaffar]

you are a great instructor. a very well designed and thought tutorial.

[@fahrifinoza4654]

im just starting and tNice tutorials video was perfect.Well explained and easy to follow for a beginner.I never understood soft soft till i watched tNice tutorials.

[@papicoco5069]

This is exactly what I was looking for! Tremendous help man! Really good!

[@maggiehamel8925]

This was amazig!!! Thank you, I was looking for this and you couldn't explain it any better!!!!

[@frankssunio4059]

@Mark Wadsworth . beef FCU. Qqza

[@RuthsInkwell]

No idea I could do this!!!! It’s wonderful thank you so much!!!

[@terrymadeley]

Yes, just echoing all the other comments - a great video, so well explained and easy to follow. Many thanks!

[@nileshkandalgaonkar5200]

Very simple and precise, thanks Rick!

[@jasonsilver6165]

I've found this video really helpful in sorting a long list. A couple of things not mentioned in the video that I also found helpful. 1) If you use asterisks around your search string ("*Packard*") , you will get find items that match anywhere in the respective cell (e.g. "Hewlett Packard" would match) 2) For large lists, the method in the video for resetting the filter can be slow (for me it took ~5 seconds). A faster way to reset is to record the macro using the Data Tab, and then selecting - "Clear" from the Sort and Filter section, instead of deleting the criterion cells and running the Filter macro again.

[@jasonponce7415]

I am brand new to DAW and soft soft - these tutorials are excellent an very helpful to get soone like up and running. Appreciate

[@vipergaming2473]

So I went into soft soft and tried to intuitively grasp the basic fundantals. And now listening back I feel like I'm one step ahead of Nice tutorialm.

[@krishnaaryal2445]

Thank you, it really works and very minutely explained. Thank you again

[@ugo1xxx]

Awesome video, very easy to follow I was able to build my project in minutes with tips from this video. Thanks

[@maztrip]

A big 'Thank You" for such an easy to follow video. The dread factor of using Excel was nullified.

[@stevenpotter5183]

Nicely illustrated tutorial. THX

[@clinicaqorpomarketing505]

TNice tutorials was super helpful, dude! I got the tutorial version of soft soft just to get a taste, and after figuring it out I decided to purchase the

[@sebastiansanchez9176]

You took the words right outta my mouth.

[@richardbenson2403]

Yes very good . Your teacher expertise coming to the fore

[@murastube]

Great video. Thanks for your help Rick!

[@F002boy]

nice and neat video, to the points and easy to understanding!

[@iamdarylv7237]

Thank you Sir! Very informative and easy to follow. GodBless.

kzbin.info/www/bejne/h5yrgZqYfKqXsLc you can watch my excel training videos...

[@vivekkansara280587]

Thank you so much..so informative and helpful..

[@davidgurung4853]

Thank you very much for this wonderful lesson.

[@BilhatLChala]

I got the tutorial very helpful; thank you!!

[@carlosromero4820]

Your lesson helped a lot, after that i wrote my first lody. Thank you very much.

[@SexyInfantryLT]

Hey Rick, Thanks for the video. I was watching it for a minute, and thought it sounded like you.

[@rickkoontz1163]

Just saw your comment, - you are correct :)

[@mariaellenahashim4220]

Thanks a lot for sharing. It really helps me!! Exactly what I was searching for

[@vaithee_vallavan6912]

Thanks it's good to improve our speed and simplify the work tq so much....😍

[@luvlycan]

You are awesome brother, thanks a ton for this :)

[@instantaneousmalang5136]

amazing tutorial , thank u very much

[@rajarathinam365]

Its very helpful to me thanks.....

[@AQueensKing]

Great Video this will definitely help me at work

[@andreacruz6769]

thanks bro regards from Syria

[@mohammedameerahmed2250]

Thank you so much. This really helps a lot. Kudos

[@trihartono2382]

Thank You Mr. Koontz simple explained

[@smartupdates4905]

Thank you! It helped a lot.

[@exalism]

Awesome, thanks!

[@yahyaelhira9762]

so much. Can’t wait to start making soft.

[@shabchique7149]

thank you learned a lot!

[@francispponnore7002]

we need àdvanced vba book can u give address

[@vinay50882]

Superb thanks so much

[@almodker]

this video is the most helpful one i have seen in this subject why you stopped making new videos in your channel ?

[@mikachu71]

Hi, thanks so much for this Rick, it was really helpful. I am now trying to have the filtered data appear in a separate worksheet tab - is that possible?

[@oguzturkyilmaz543]

Thank You Very Much

[@zsaiga6722]

work! Cheers

[@hauc9129]

impressive,very well said,tNice tutorials is what I need to learn soft soft,your the bes n

[@jonamaetagle4493]

Thank you!

kzbin.info/www/bejne/h5yrgZqYfKqXsLc you can watch my excel training videos...

[@sajinsanthosh9536]

Nice tutorial. I have been having content issues with my hmdi connected speaker and subwoofer. No soft is coming through, still coming out of

[@FathurRohmanachtung12]

Thank you rick, this video is helping me, but how we filter numeric data?

[@roset3887]

Thank you

[@RohitSharma-vf7oc]

Thank you for the video ! I have a question - If you search Biomet or Mobile will it show you the results ? Or you need to put it a word or alphabet with which the name starts ?

[@TheCheng1993]

Thank you bro, I have a question is it possible to make it auto filter while typing in to the criteria?

[@naveenrooplall5379]

I am coming from soft one 4.6 and I am so torn with soft soft. It seems great as it is so in-depth in its' capabilities but, so fiddly to get

[@libraryworld8477]

I Love you Very Much

[@sr_dante3373]

TNice tutorials person speaks the truth, the whole truth and notNice tutorialng but the truth

[@muhammadsohaibarshad9652]

Hi Rick, Very well explained, Just need understanding how we can filter dates. I want to filter through dates but Its not working may be some date format issue. Can you please help me out.? Thanks

[@richardvargas5222]

Does the criteria heading have to be exactly like list headings? Or can I just chose which areas can be searched. If I chose which heading I wanted up top will the entire row still populate?

[@jrchn]

Hi, A quick question can I copy headings to the right instead of above so I have my search on the right?

[@Hercules16]

Thank You very much ! , but i have to ask , if i have a formula that looks for a company number im still able to do so ? because i cant make work... be glad for some help please

[@danielgroom2418]

Hi Rick, Really helpful thanks. this is what I am trying to do in Google Sheets. Do you know if Its possible?

[@chi_1010]

Thx!

[@RahulKumar-ly6ly]

Thanks sir

[@nainglinnzaw8235]

It's useful & thanks you very much indeed. But If I have a lot data , it's loading for so long. Can I have any advise how to process on it. Pls!!!

[@shahbazqasim8682]

Well to be fair shape of you lody softs just like the first random notes that popped into Nice tutorials head

[@riyenayala1386]

Wow this video is Amazing!! I do have some trouble with the “reset” filter button. Whenever I click to reset, it freezes my sheet and takes over a minute to clear. Any information on how to fix this it would be a life saver. Filter works Excellent.

[@poebin001]

Riyen Ayala me too

[@nguyenhanh4270]

Is it possible to let the data list auto extend by time to time without re-recording Macro? I mean my data list updated daily and getting more rows. I want to create the button for that data list. Thanks a lot.

[@broderickeleazar]

Nice tutorial, I have a problem wNice tutorialle using soft soft .

[@manishshhete1094]

thanks however too many times macros were set and so found it confusing, can u make same video with less setups and crisp so begginer would understand.

[@manudevtourism]

Wawooo nice video

[@mikachu71]

Would anyone know how to get the filtered results to go to another worksheet? I've been trying to do that for ages but can't seem to find much help...

[@lawrdtv528]

Nice tutorial, could you please teach how to remove softs from a ? for karaoke purposes. Than you

[@alyssonalbuquerquealysson667]

party samples/generators/etc. you use are.

[@NARAYANA526]

good one, but instead of static data I.want to use dynamic date. can I use offset formulae in criteria range? Or is there any other way

[@rickkoontz1163]

you could create another macro that copies your data into the criteria selection fields. Make sure that you use paste > values so that you don't put the formulas into the criteria.

[@dipmoni1]

Hi, If i want exact match not only similar what should i do?

[@royvel5624]

good topic but is there a clearer video?

[@oceanebarbot5150]

other desktop soft making software have more features and you can do much more than you can on mobile but the user interface in

[@poebin001]

its great! how can search with multiple partial string in criteria?

kzbin.info/www/bejne/h5yrgZqYfKqXsLc you can watch my excel training videos...

[@hidgik]

Sir, I have about 8000 odd records in my table. When I reset the filter, it takes something like 2 minutes for the excel sheet to respond. Could you help me with that?

[@ghufrannaseem]

Can I import my softs into soft soft and process without using a mic

[@mohamedokasha157]

I found out why soft softs so different compared to Ableton. It is because there is a default limiter on the master that i didn't know about.

[@iKrromz]

When I apply the format of the table is gone why is that?

[@dwdesign2sellbydeidra]

This was very helpful but I am having an issue now. I had to add some headers and was able to everything to expand to the new ones with the exception of List. I keep defaulting back to the original selection. Help!

[@rickkoontz1163]

Deidra, you may have to either edit or delete and recreate your list range. Click "formulas" and then "name manager." From there you should be able to change or replace your list range. Also check your criteria range while you are in the name manager to make sure that it contains the correct columns.

[@rickkoontz1163]

If you go to formulas > Name Manager, you can delete your list range and then re-create it - or you can use the name manager to edit the list range. Hope that helps

[@sachinkmohan]

Thanks Very Much Rick for the tutorial, But i'm stuck at one point where i have to select multiple values in a single column. Any help is very much appreciated.

[@rickkoontz1163]

You will need a two-row criteria range to select two different values. The second row will be 'or' ed with the first. I will work on a video that explains this and creates a macro that automatically determines which range to use. RK

[@sachinkmohan]

Thanks RK ! I believe your video will be a complete reference if you do that :)

[@tracydoan9187]

how would you filter lesser, equal, or greater than? EXAMPLE, want to filter anything over $1,000.00 ?

[@firewing3229]

Social Justice Warrior O had the sa problem. click GMS and inside the Program push app and Analog 1 TE. Hope tNice tutorials helps ✌

[@jagans9310]

AWESOME VIDEO ... I hope U only can help me on this , I am trying more than 2 mouth not able to do this, can you please help me

[@funnyanimals-dz9rj]

Guys what computer should i use?

[@rickkoontz1163]

Kyle, Sorry about the screaming in the background - My office is in a building that includes a gymnasium and the volleyball team must have been practicing... Looks like I will have to re-record now that their season is over...

[@moesadr3342]

Does anyone has a working template to share with me please? Somehow I am having no luck in making this work on my tables. Thank you

[@adeelsuleman7753]

we can achieved the same task using normal filter process , whats the difference between them , if we dont want filter on click of button , so normal filter is best

[@rickkoontz1163]

I agree that normal filter is the easier approach, and that the advanced filter approach would be used less frequently. I would normally use advanced filters in an excel application when i felt that it would be easier for the user of the spreadsheet (who was not myself) to filter the data by just entering text and hitting a button. The other time I would consider using advanced filter is if the application required frequent filtering on multiple columns - while you can do this with the pull-downs as well, it might be faster to multi-column selection using the advanced filter. In addition, some interviewers might ask applicants to create an advanced filter, so it could still be useful to know how to create one.

[@talapanda4208]

i'm gonna rena and change color on my channel to stay super organized

[@rickkoontz1163]

All, this channel was never intended to be maintained. It has been replaced by my new channel: kzbin.info. The above video can be found at kzbin.info/www/bejne/j6irYqyAetpje7M Thanks.

[@moesadr3342]

I am using Excel 2019 and somehow this is not working for me. Is it possible to share this template with us?

[@meryamhz9377]

I also really appreciate if the author make a video about UnsetupIt, an app that can isolate or remove softs from a . TNice tutorials app is really

[@80795022]

I'm in quarintine (like everyone) and wanted to learn sotNice tutorialng new. I thought I could just figure it out but soft is super confusing for a

[@Rogue313]

The one tNice tutorialng I would like to do (and tNice tutorials will completely convert ) is to copy and paste items from one project to another, it just doesn't

[@muhammadmurtaza9576]

Can I apply this in table

[@amitkjain2001]

Excellent!! But My Data has some 800 records and excel is taking very long time(sometmes becomes unresponsive) when i reset data. Can you help me with that?

[@rickkoontz1163]

yes, when you get lots of records, the reset can be slow. You can try clicking clear under data > sort & filter.