In this Short 1 minute video on Excel Tips & Tricks, we discuss the SORT Function in Excel.
Excel SORT function sorts the contents of a range or array in both ascending and descending order. You can sort the values by one or more columns. SORT returns a dynamic array of results.

=SORT (array, [sort_index], [sort_order], [by_col])
Array (required) – the range or array from which to return unique values.
Indicates which column or row to sort by Default is 1
1 = Ascending,
-1 = Descending.
Default is ascending order
TRUE-sort by column
FALSE = sort by row
Default is FALSE

The function is an array function i.e. the result automatically spills into the neighbouring cells vertically or horizontally.

My other videos on Using Excel 👇
⚡ UNIQUE Function https://youtu.be/VXcDLOjOuhg
⚡ SORT Function https://youtu.be/kIO0E6vPvis

TOP 10 EXCEL TIPS in Hindi/English Series
#1 Quick Access Toolbar https://youtu.be/OOuvqvSH8A8
#2 Keyboard Shortcuts https://youtu.be/tu52UdJR5MM
#3 Custom Sort https://youtu.be/sThclPC2AIU
#4 Horizontal Sort https://youtu.be/DHKrDDYq_1o
#5 Go to Special https://youtu.be/SofqWqJu27E
#6 Advanced Filter https://youtu.be/QD_lCjqI1us
#7 Table https://youtu.be/IVGIBq7tY6I
#8 Subtotal https://youtu.be/AnEfgHP4g90
#9 Consolidate https://youtu.be/WERAbDJ3ga8
#10 Flash Fill https://youtu.be/PpDr4JPdT5U
Excel Tips & Tricks- Hindi
#Pivot Table https://youtu.be/KFJJIRPytPg
#80/20 Rule with Pivot https://youtu.be/N5_oTaD2bJI

Excel Productivity Hacks
◾Autofilter, Flash Fill https://youtu.be/IGjw-YFHvLU
◾Using Tables https://youtu.be/nKJdgFtjZ_E
◾Consolidate https://youtu.be/7AwJLMJ6OeE
◾TEXTJOIN https://youtu.be/o-7uLzl7J6k
◾SUBTOTAL https://youtu.be/01rrV7_fw64
◾SUBTOTAL Outline https://youtu.be/tVhdN9orSQ8
◾Evaluate Formula https://youtu.be/-6iSLH-x8b0
◾ANALYZE DATA https://youtu.be/KnkkVStpr_Q
◾CONDITIONAL FORMATTING-1 https://youtu.be/wAW1v5XlLUI
◾CONDITIONAL FORMATTING-2 https://youtu.be/9L6dmsEGNzY

3 Simple Powerful Tools for Tax Audit 🎯
#1 Excel https://youtu.be/bGzoTGtdNb4​
#2 eCAAT https://youtu.be/3vl4KXyuO44​
#3 MDA Audit Tool https://youtu.be/V_alqesIUhI

Excel as an Audit Tool https://youtu.be/Ne3w6Jj2ZSU
The Data Analysis Story with Excel https://youtu.be/0ZUxLCDUNsc
Analytical procedures using Excel https://youtu.be/Nd2OnCrl34M

Bank Audit Series
Part 1: How to convert bank reports to Excel

Part 2: How to use Filter in Excel to analyse Loan Balance Report. https://youtu.be/4Z6W40gSWOA
Part 3: How to use the Power of Pivots to analyse Loan Balance Report. https://youtu.be/whdEZDSdoIM
Bank Audit in Computerised Environment

1. Thumbs up, if you learned something new today. 👍
2. Subscribe to get regular updates on Excel.
3. Comment below with your biggest takeaway from this video.

#SORT,#Dynamicarrayfunctions, #Exceltips, #Exceltraining, #SORTFUNCTION #msmehta, #auditwithexcel, #charteredaccountant, #Advancedexceltraining, #Advancedexceltips, #Advancedexceltips, #MicrosoftExcel, #ExcelTipsandtricks

🚩 Connect with me
✅Website: https://www.msmehta.com
✅Email: msm@msmehta.com
✅LinkedIn: https://www.linkedin.com/in/manmeetmehta
🔔Subscribe to my YouTube channel: https://www.youtube.com/c/ManmeetSinghMehta?sub_confirmation=1

Leave a Reply

Close Menu