Okebiz Video Search



Title:Sort on Multiple Columns at Once in Excel - Excel Quickie 27
Duration:02:59
Viewed:6,396
Published:12-12-2019
Source:Youtube

Excel Quickie 26: https://www.youtube.com/watch?v=XrRvG...

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

SHARE TO YOUR FRIENDS


Download Server 1


DOWNLOAD MP4

Download Server 2


DOWNLOAD MP4

Alternative Download :



SPONSORED
Loading...
RELATED VIDEOS
Return Multiple Match Results in Excel (2 methods) Return Multiple Match Results in Excel (2 methods)
14:13 | 771
10 Super Neat Ways to Clean Data in Excel 10 Super Neat Ways to Clean Data in Excel
18:47 | 507,070
Excel - Sorting Data, Multiple Columns, Date, Color - Avoid Disasters! Excel - Sorting Data, Multiple Columns, Date, C...
26:21 | 870
Excel shortcut keys you SHOULD know! Excel shortcut keys you SHOULD know!
08:48 | 13,300
Secrets to Building Excel Dashboards in Under 15 Minutes! Secrets to Building Excel Dashboards in Under 1...
13:20 | 585,835
Combine or Transpose Text from Multiple Rows Combine or Transpose Text from Multiple Rows
07:42 | 41,700
How to sort by multiple columns in Excel How to sort by multiple columns in Excel
02:06 | 87,679
MS Excel - Data Sorting MS Excel - Data Sorting
09:05 | 438,317