Okebiz Video Search



Title:How to Do Multi level sorting in Excel (by two Columns)
Duration:05:36
Viewed:59,670
Published:15-05-2018
Source:Youtube

In this video, I'll show you how to do a multi-level sorting in Excel. This means that you sort data by 2 or more columns.

You can read more about it here: https://trumpexcel.com/multiple-level...

When working with data in Excel, sorting the data is one of the common things you might have to do.

In most of the cases, you need to sort a single column.

But in some cases, there may be a need to sort two columns or more than two columns.

There are two ways to do this - using the Sort dialog box and using the Sort icons. You can find these options in the Data tab in the Excel ribbon.

In the Sort dialog box, you can specify the order of sorting. You can add a sorting level and then you can add more sorting levels below it.

You can also use the sort icons, which needs to be used in the reverse order. So if you want to sort Column A and then Column B, you use sort icon on Column B first and then use it in Column A.

It is recommended to use the Sort dialog box as it less confusing and allows you to sort based on other parameters as well - such as cell color, font color or cell Icon.




Free Excel Course - https://trumpexcel.com/learn-excel/
Paid Online Training - https://trumpexcel.com/excel-training/
Best Excel Books: https://trumpexcel.com/best-excel-books/

⚙️ Gear I Recommend:
Camera - https://amzn.to/3bmHko7
Screen Recorder - techsmith.z6rjha.net/26D9Q
USB Mic - https://amzn.to/2uzhVHd
Wireless Mic: https://amzn.to/3blQ8uk
Lighting - https://amzn.to/2uxOxRv

Subscribe to get awesome Excel Tips every week: https://www.youtube.com/user/trumpexc...

Note: Some of these links here are affiliate links!

#Excel #ExcelTips #ExcelTutorial

SHARE TO YOUR FRIENDS


Download Server 1


DOWNLOAD MP4

Download Server 2


DOWNLOAD MP4

Alternative Download :



SPONSORED
Loading...
RELATED VIDEOS
Compare Two Lists Using the Vlookup Formula Compare Two Lists Using the Vlookup Formula
12:49 | 739,480
Excel Sort Data (by Value, Color, Icon, Own List) & How to Unsort Excel Sort Data (by Value, Color, Icon, Own Lis...
11:09 | 77,505
10 Super Neat Ways to Clean Data in Excel 10 Super Neat Ways to Clean Data in Excel
18:47 | 374,406
MS Excel - Data Sorting MS Excel - Data Sorting
09:05 | 335,779
50 Ultimate Excel Tips and Tricks for 2020 50 Ultimate Excel Tips and Tricks for 2020
50:17 | 475,963
Qualitative Analysis: Coding and Categorizing Data by Philip Adu, Ph.D. Qualitative Analysis: Coding and Categorizing D...
15:43 | 86,285
Excel 2007 - Sorting Data In Single Columns And Whole Tables Excel 2007 - Sorting Data In Single Columns And...
07:25 | 296,863
Introduction to Pivot Tables, Charts, and Dashboards in Excel (Part 1) Introduction to Pivot Tables, Charts, and Dashb...
14:48 | 886,154


coinpayu