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!!
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.
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
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.
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 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
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 ?
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?
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
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.
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.
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.
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.
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!
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.
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
All, this channel was never intended to be maintained. It has been replaced by my new channel: ruclips.net/user/koontzrd. The above video can be found at ruclips.net/video/YwH1yJEu0EQ/видео.html Thanks.
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...
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?
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.
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
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.
It actually sounded more like a bunch of children playing in a wide open indoor area that echoes, such as a gym. But yeah, the video was really useful.
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
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
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.
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?
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!!
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.
This tutorial was GREAT!!! Thank you. I was able to replicate it to many of my lists and they worked! Very GRATEFUL!!
I am brand new to DAW and soft soft - these tutorials are excellent an very helpful to get soone like up and running. Appreciate
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
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.
you are a great instructor. a very well designed and thought tutorial.
This is exactly what I was looking for! Tremendous help man! Really good!
You took the words right outta my mouth.
This was amazig!!! Thank you, I was looking for this and you couldn't explain it any better!!!!
@Mark Wadsworth . beef FCU. Qqza
A big 'Thank You" for such an easy to follow video. The dread factor of using Excel was nullified.
Very simple and precise, thanks Rick!
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.
Yes, just echoing all the other comments - a great video, so well explained and easy to follow. Many thanks!
No idea I could do this!!!! It’s wonderful thank you so much!!!
Thank you, it really works and very minutely explained. Thank you again
Awesome video, very easy to follow I was able to build my project in minutes with tips from this video. Thanks
Nicely illustrated tutorial. THX
Your lesson helped a lot, after that i wrote my first lody. Thank you very much.
nice and neat video, to the points and easy to understanding!
Great video. Thanks for your help Rick!
Thank you very much for this wonderful lesson.
Hey Rick, Thanks for the video. I was watching it for a minute, and thought it sounded like you.
Just saw your comment, - you are correct :)
I got the tutorial very helpful; thank you!!
Thank you Sir! Very informative and easy to follow. GodBless.
ruclips.net/video/QkHPgbGEdzU/видео.html you can watch my excel training videos...
Thank you so much..so informative and helpful..
Yes very good . Your teacher expertise coming to the fore
amazing tutorial , thank u very much
Thanks it's good to improve our speed and simplify the work tq so much....😍
You are awesome brother, thanks a ton for this :)
this video is the most helpful one i have seen in this subject why you stopped making new videos in your channel ?
Thanks a lot for sharing. It really helps me!! Exactly what I was searching for
thanks bro regards from Syria
Great Video this will definitely help me at work
Thank You Mr. Koontz simple explained
TNice tutorials person speaks the truth, the whole truth and notNice tutorialng but the truth
Thank you so much. This really helps a lot. Kudos
Its very helpful to me thanks.....
Awesome, thanks!
Thank you! It helped a lot.
so much. Can’t wait to start making soft.
thank you learned a lot!
we need àdvanced vba book can u give address
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?
impressive,very well said,tNice tutorials is what I need to learn soft soft,your the bes n
Superb thanks so much
Well to be fair shape of you lody softs just like the first random notes that popped into Nice tutorials head
Thank You Very Much
Thank you!
ruclips.net/video/QkHPgbGEdzU/видео.html you can watch my excel training videos...
Thank you bro,
I have a question is it possible to make it auto filter while typing in to the criteria?
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
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 ?
work! Cheers
Thank you rick, this video is helping me, but how we filter numeric data?
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?
Hi, A quick question can I copy headings to the right instead of above so I have my search on the right?
Nice tutorial. I have been having content issues with my hmdi connected speaker and subwoofer. No soft is coming through, still coming out of
Thank you
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
I Love you Very Much
Social Justice Warrior O had the sa problem. click GMS and inside the Program push app and Analog 1 TE. Hope tNice tutorials helps ✌
Hi Rick, Really helpful thanks. this is what I am trying to do in Google Sheets. Do you know if Its possible?
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 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
Thx!
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.
Riyen Ayala me too
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 sir
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
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.
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...
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.
Wawooo nice video
Nice tutorial, I have a problem wNice tutorialle using soft soft .
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.
Hi, If i want exact match not only similar what should i do?
its great!
how can search with multiple partial string in criteria?
ruclips.net/video/QkHPgbGEdzU/видео.html you can watch my excel training videos...
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
good topic but is there a clearer video?
Nice tutorial, could you please teach how to remove softs from a ? for karaoke purposes. Than you
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!
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.
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
other desktop soft making software have more features and you can do much more than you can on mobile but the user interface in
All, this channel was never intended to be maintained. It has been replaced by my new channel: ruclips.net/user/koontzrd. The above video can be found at ruclips.net/video/YwH1yJEu0EQ/видео.html Thanks.
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...
i'm gonna rena and change color on my channel to stay super organized
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?
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.
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
Thanks RK ! I believe your video will be a complete reference if you do that :)
When I apply the format of the table is gone why is that?
Can I import my softs into soft soft and process without using a mic
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.
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.
It actually sounded more like a bunch of children playing in a wide open indoor area that echoes, such as a gym. But yeah, the video was really useful.
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
party samples/generators/etc. you use are.
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
how would you filter lesser, equal, or greater than? EXAMPLE, want to filter anything over $1,000.00 ?
I am using Excel 2019 and somehow this is not working for me. Is it possible to share this template with us?
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
how to use SQL in excel ...
I want to use group by and order by . plz help
ruclips.net/video/QkHPgbGEdzU/видео.html you can watch my excel training videos...
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
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.
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?
yes, when you get lots of records, the reset can be slow. You can try clicking clear under data > sort & filter.