Advanced sorting methods in Excel that allow you to sort on multiple columns at the same time.
This is a great little trick that allows you to quickly and simply organize large lists of data to more easily visualize what you need for your work.
This Excel quickie uses custom or advanced sorting methods and covers everything you need to get the job done.
Another benefit of sorting like this, which I forgot to mention in the video, is that you can search the data to return the lowest or highest values in a list with duplicate values simply by sorting the data first – this allows you to use simpler search formulas and still get the results you need.
I hope you enjoy this Excel Quickie!
TeachExcel.com
#excel #tutorial #sorting
Please take the opportunity to connect and share this video with your friends and family if you find it useful.
No Comments