Excel Quickie 26:
Advanced sorting methods in Excel that allow you to sort by multiple columns at the same time.
This is a great little trick that allows you to quickly and simply organize large lists of data in order to more easily view what you need for your work.
This Excel quickie uses the custom or advanced sorting methods and covers everything you need to get the job done.
Another great thing with sorting like this, which I forgot to mention in the video, is that you can perform lookups on the data to return the lowest or highest values from a list with duplicate values simply by first sorting the data – this allows you to use simpler lookup formulas while getting the results that you need.
I hope you enjoy this Excel Quickie!