Updated : Dec 30, 2019 in Công Nghệ✅

Sort on Multiple Columns at Once in Excel – Excel Quickie 27



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!

TeachExcel.com

#excel #tutorial #sort

Nguồn: https://dungquatiz.com/

Xem thêm bài viết khác: https://dungquatiz.com/category/cong-nghe/

6 Comments

  • Thanks for the video. You can also sort in groupings quickly without resorting to the formal sort dialog by doing successive column sorts in the reverse order of priority. So, for example, if you want to end up sorted by Name and then Total from highest to lowest within each name grouping, first sort on Total, then sort on Name. You will end up on the same place as using the formal sort menu and setting up multiple sort levels, as you demonstrated in the video. Of course, the formal sort menu has many more features and options. But, for doing it quickly, you can get there with a couple of right clicks, as long as you do it in the reverse order of priority. Thanks again for your tips.. always something new and interesting. Thumbs up!

  • Dear thanks for all you excel VDOs… Please help me to automate some excel work … I want to Run a macro after or whenever query auto-refreshes by Refresh Time … is it possible. PLEASE REPLY.

Leave a Reply

Your email address will not be published. Required fields are marked *