Excel SORT Function | Excel One Minute Functions Explained

preview_player
Показать описание
The SORT function in Excel sorts the contents of a range or array. Example, =SORT(B2:B20). You can also sort in ascending or descending order with the SORT function. =SORT(B2:B20,,-1) would sort descending or highest to lowest. The number 1 would sort ascending, which is the default sort. The SORT function has four arguments, but only 1 is required.

Blog post by Chris Menard on SORT function

Syntax
=SORT(array,[sort_index],[sort_order],[by_col])

Argument Description
****************
array - The array or range to sort - Required
[sort_index] A number indicating the row or column to sort by
[sort_order] - The order to use for sorting. 1 for ascending, -1 for descending. Default is ascending.
[by_col] - A logical value indicating the desired sort direction; FALSE to sort by row (default), TRUE to sort by column

Other videos on the SORT & SORTBY functions by Chris Menard

Versions of Excel the SORT function works in
Excel for Microsoft365
Excel for Microsoft 365 for Mac
Excel for the web
Excel 2021
Excel 2021 for Mac
Excel for iPad
Excel for iPhone
Excel for Android tablets
Excel for Android phones

Note about the SORT Function
The SORT function is provided to sort data in an array. If you want to sort data in the grid, it's better to use the SORTBY function, as it is more flexible. SORTBY will respect column additions/deletions, because it references a range, where SORT references a column index number.

#exceltraining #microsoft #microsoftexcel #chrismenard #chrismenardexcel #chrismenardtraining

And make sure you subscribe to my channel!

-- EQUIPMENT USED ---------------------------------

-- SOFTWARE USED ---------------------------------

DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links I provide, I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel, so I can continue to provide you with free content each week!
Рекомендации по теме
Комментарии
Автор

Nice!!! I am preparing for the MO211, so a lot of stuff in very short time. This is perfect.

nairobi
Автор

Thank you for the short excelled videos they are really really helpful and useful to me. Please keep going

SenorDroolcup
Автор

Best excel videos! Love your shirts. Lol

kendraharvey
Автор

Could you please explain the last argument of the sort function please!

sharifulislam
Автор

It doesn't alter the order in not selected columns? Just the column to be sorted? Thanks for your video

microguard
Автор

Why dint you provide the example file along with this tutorial, for us to practice?

kashif
Автор

Is there a way to add the presence of data in a cell? I am looking to add cells that have data present to another cell. Like, out of 5 cells, there is data in 3, and have a cell that shows that there is data present in 3 cells but not display the data in those 3, just that there is data present. Is there a data validation system of some sort that will do that?

factoryspeed
Автор

How do i sort through and choose a certain number out of my worksehhet that i need to delete

ohhi
Автор

tell me youre from georgia without telling me youre from georgia.

deloach
welcome to shbcf.ru