You have no idea how much this simple trick is so handy. It just goes to show me that if I don't specialise in specific areas like you do, for example, it becomes important for me to keep watching your videos because there are gems that await me to help me become more productive. Thank you
Learned this technique the hard way. At least I could start from scratch (external data source). Also extremely useful for deleting a sizable number of rows. I had a 50K-row table, and I needed to delete all the 0 amount rows (20-30%). Filtering, and deleting is PAINFULLY SLOW. Sorting first, though, to get all the records together provided a huge speed increase. An index field is not necessary in this case, but maintaining an original order makes it necessary. An additional benefit of the index field is serving as a unique key to the data.
Been doing that and sharing it for 30 years. It's a great tip and a real lifesaver with financial data or any data where sequential event / transactional order is paramount.
Thank you so much for all HUGE INFORMATION that you share with all us!!! You are amazing, very easy to understand, you explain everything so well, let me know if you give classes 👍🤩
How can the filter function be used if the search for a number or letter can be in the first, middle, or end of the condition? For example, I want to filter all products that end with the number 5
Great question! Here's an awesome article from from my friend Chris on partial matches with FILTER. www.thespreadsheetguru.com/blog/wildcard-filter-function? I hope that helps. Thanks again and have a nice day! 🙂
Is there a way to sort track numbers like 1., 2, 3, ...15., 21., etc but with a "." after the number. When I try to sort them, it puts "2." right before "20.", but after "15.".
If you have version history on your file (such as through OneDrive or SharePoint), you can view an older version of your file that contained the old sort order, then make changes in your current file to match that order. Or, if you got the data from an outside source, getting the data again in a new file may provide clues as to what the old sort order was. I hope that helps, Arpit! 😊
Selecting multiple columns allows you to sort by multiple categories, say by Date, then item, or item, then date, etc, from whichever you column you select first.
Thank you 🙏🏻 so much!!! I always had troubles to get to the original back…. 😅 It was frustrating!!! But not anymore
You have no idea how much this simple trick is so handy. It just goes to show me that if I don't specialise in specific areas like you do, for example, it becomes important for me to keep watching your videos because there are gems that await me to help me become more productive. Thank you
Great to hear that, Morena! Thank you! 😀
Learned this technique the hard way. At least I could start from scratch (external data source).
Also extremely useful for deleting a sizable number of rows. I had a 50K-row table, and I needed to delete all the 0 amount rows (20-30%). Filtering, and deleting is PAINFULLY SLOW. Sorting first, though, to get all the records together provided a huge speed increase. An index field is not necessary in this case, but maintaining an original order makes it necessary. An additional benefit of the index field is serving as a unique key to the data.
Been doing that and sharing it for 30 years. It's a great tip and a real lifesaver with financial data or any data where sequential event / transactional order is paramount.
wow, I never thought of this. Now I won't be afraid to use the sorting tool anymore :D
Awesome! I'm happy to hear it. Thanks Oscar! 🙂
An excellent technique. Thank you
Thank Jon
I love you man, you saved me a lot of time ❤
Thanks Jon. Helpful as always 👍
You're welcome, Joydeep! 😀
Thankkkkkk Youuuuuuuu!!!!
Really really helpful
Glad it helped @CictionalFharachter 😀
Thank you so much for all HUGE INFORMATION that you share with all us!!! You are amazing, very easy to understand, you explain everything so well, let me know if you give classes 👍🤩
You are so welcome, Guadalupe! 😀 You may check this link for more information of our Elevate Excel course www.excelcampus.com/elevate-excel-invite/
I knew that one, I was hoping for something already integrated in Excel! Thanks anyway, it does the job!
Agree it would be a nice to have feature. 👍
wow. this is what i need
Glad to hear that! 😀
U r amazing! Solved my long time question
Thanks Isabella! I appreciate your support. 👍
Brilliant
Thanks, Abram! :)
Wow 🤝
How can the filter function be used if the search for a number or letter can be in the first, middle, or end of the condition? For example, I want to filter all products that end with the number 5
Great question! Here's an awesome article from from my friend Chris on partial matches with FILTER.
www.thespreadsheetguru.com/blog/wildcard-filter-function?
I hope that helps. Thanks again and have a nice day! 🙂
@@ExcelCampus Thanks for all your assistance, and also, for posting what you do.
You're welcome, Ceteris! 😀
Instead start in row 2 with the number 2 so that both are in agreement. You can put 1 in the header if you like, or just omit it.
Is there a way to sort track numbers like 1., 2, 3, ...15., 21., etc but with a "." after the number. When I try to sort them, it puts "2." right before "20.", but after "15.".
I have not done indexing now please guide how to get old sort order
If you have version history on your file (such as through OneDrive or SharePoint), you can view an older version of your file that contained the old sort order, then make changes in your current file to match that order. Or, if you got the data from an outside source, getting the data again in a new file may provide clues as to what the old sort order was. I hope that helps, Arpit! 😊
Selecting multiple columns allows you to sort by multiple categories, say by Date, then item, or item, then date, etc, from whichever you column you select first.