Excel 2013 Advanced Filter using a Macro 

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.

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

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!!

You took the words right outta my mouth.

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

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.

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

Yes very good . Your teacher expertise coming to the fore

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

thanks bro regards from Syria

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

All, this channel was never intended to be maintained. It has been replaced by my new channel: ru-vid.com. The above video can be found at ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-YwH1yJEu0EQ.html Thanks.

Nicely illustrated tutorial. THX

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

Great video. Thanks for your help Rick!

Thank you very much for this wonderful lesson.

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

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

Did nobody else hear the screaming in the back? Sounded like a possessed young child!? I mean the vid helped....thanks. That was scary though. Please tell me your not holding kids.

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

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

amazing tutorial , thank u very much

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...

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

Thank u sir... I have seen many videos bt didn't get a satisfy result.. Ur vdo is awesome.. I need this..for my project. Can I have Ur Skype id.. for future contact. In excel problem..??

Superb thanks so much

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

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.

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

Its very helpful to me thanks.....

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

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

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.

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.

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.

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

like tNice tutorials are genuinely ant, it helps make the world a better place. Thank you for the amount you wrote too, I can tell you sincerely care.

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

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

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

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

I have loved soft all my life but felt trapped and muted by the fact that I couldn't create my own. Over the last or so years I've tried

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

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

TNice tutorials is not what i see when I open soft soft at all.

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.

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

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

but I guess I just have to deal with bluetooth, tNice tutorials is a big con.

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

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

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

Thank You Very Much

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

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

how to use SQL in excel ... I want to use group by and order by . plz help

good topic but is there a clearer video?

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.

I already made a soft in like 3 hours its that hard

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

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

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!!!

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

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

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?

I got the tutorial very helpful; thank you!!

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

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

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

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

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 ?

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!

can i do tNice tutorials with the trial version?

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

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.

party samples/generators/etc. you use are.

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

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

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

Guys what computer should i use?

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

I think hlookup function is better than advance filter by filtering the data

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

U can filters to it and be done with it lol

Thank You Mr. Koontz simple explained

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?

Thank you! It helped a lot.

Awesome, thanks!

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

Can I apply this in table

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

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?

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

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

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?

wondering if u would be willing to collab to make a . TNice tutorials would be my first and I would understand and apprehensions you may

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

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

work! Cheers

Thanks sir