Module 12 - SORT Function | New Creation | Tamil | Excel Specialist
SORT Function in Excel
1. How to use SORT Function
2. SORT Function for preferredColumn
3. SORT Function - Ascending and Descending Order
4. SORT Function - By Column
Purpose :
The Excel SORT function sorts the contents of a range or array in ascending or descending order. Values can be sorted by one or more columns. SORT returns a dynamic array of results.
Arguments:
array - Range or array to sort.
sort_index - [optional] Column index to use for sorting. Default is 1.
sort_order - [optional] 1 = Ascending, -1 = Descending. Default is ascending order.
by_col - [optional] TRUE = sort by column. FALSE = sort by row. Default is FALSE.
Return value:
Sorted array
Syntax:
Sorted array
Source from Excel Jet
_______________________________________________________________________
New Creation Excel Tutorial channel helps you to learning the below
1. Excel Function and its behavoir
2. Day to Day work life Excel shortcuts
3. Magic Tips and tricks
4. Macro and VBA for your work automation
Thank you so much in advance for subscribe, turn on notifications, likes & Comments...
Follow us on Insta - @newcreationexcel
#excel #exceltips #exceltricks #exceltricks #dataanalytics #datascience #data #vlookup #lookup #xlookup #@newcreationexceltutorial2 #pivot #pivot_table #filter #filterfunction