In our last blog, we discussed the new Unique function in Excel. In this blog, we will discuss about the newly introduced Sort Function, which is also useful for analyzing large data sets. This function has been introduced in Microsoft Excel 365. It is not available in earlier versions of excel.
Sort Function Arguments
The Sort Function has 4 arguments.
Array :- It is the range or array to be sorted
Sort_Index :- It is the row or column in the dataset to be sorted. The input for this argument is a number.
Sort_Order :- It is the desired sort order. The input is a number. 1 represents Ascending order and -1 represents Descending Order.
By_Col :- In most cases, the values are sorted by the rows. The default value for this argument is “False”. So, if we do not enter anything for this argument, excel would sort the values by the rows in a selected column. If we want to sort the values by column (rare situations), we should enter “True” in the argument.
Let us understand the Sort Function with the help of a few examples.
Click to learn top 10 financial functions in Excel
Example 1 – Sorting a List of Names ascending order
Here is a list of customer names who visited the store this week and sales made.
To sort the list in alphabetical order, Type
=Sort(B:6:B12). Press Enter.
We get the list sorted in alphabetical order (see below).
Example 2 – Sorting a List of Names in descending order
Here is a list of customer names who visited the store this week and sales made.
To sort the list in descending order, we will use the first and third argument of the Sort function.
=Sort(B:6:B12,,-1). Press Enter.
We get the list sorted in descending order (see below).
Example 3 – Sorting a List of Names with sales made in descending order.
Here is the list of customers and sales made last week. We want to organize the data in descending order by total sales.
To sort the data in descending order by total revenues, we will use the first 3 arguments of the sort function. Type
=Sort(B6:E12,4,-1)
B6:E12 is the range to be sorted.
4 is the column in the range to be sorted.
-1 is for descending order.
When we Press Enter. We get the following table sorted in descending order.
If we type B5:B12 as the range. Excel recognizes that the first row is table header. It gives the following table.
Example 4 – Sorting a List of Unique Names of Customers.
Here is a list of names of customers who visited the store during this month. Names of a few customers is appearing more than once in the list.
We are required to create a list of unique names sorted in alphabetical order.
To create a list of unique names sorted in alphabetical order, we will use the Unique and sort functions combined.
To create the unique list we will type.
=Unique(B5:C15)
We get this list of unique names.
Then we will use the Sort function along with the Unique function to sort the list in alphabetical order.
Type
=Sort(Unique(B5:C15))
Press Enter.
Now we get the list sorted in alphabetical order.
To combine the first and last names, we can modify the formula a bit.
Type
=Sort(Unique(B5:B15&” “&C5:C15))
Press Enter
Now you get the sorted list with first and last names in the same column.
This is how we can use the Sort function. It can be used for analyzing large data sets.
Click to learn data analysis with Pivot Tables
Let us know in case you have any questions, by posting in the comment section below.
Happy learning.
25 thoughts on “The SORT Function for Data Analytics in Excel”
[…] you want to know how to sort in excel, here’s an example: You want to sort this list in ascending order (from lowest to highest), […]
… [Trackback]
[…] Find More Info here on that Topic: skillfine.com/excel-sort-function/ […]
… [Trackback]
[…] Info to that Topic: skillfine.com/excel-sort-function/ […]
… [Trackback]
[…] Find More on to that Topic: skillfine.com/excel-sort-function/ […]
… [Trackback]
[…] Read More here on that Topic: skillfine.com/excel-sort-function/ […]
… [Trackback]
[…] Find More on on that Topic: skillfine.com/excel-sort-function/ […]
… [Trackback]
[…] Information on that Topic: skillfine.com/excel-sort-function/ […]
… [Trackback]
[…] Read More Information here to that Topic: skillfine.com/excel-sort-function/ […]
… [Trackback]
[…] Read More on that Topic: skillfine.com/excel-sort-function/ […]
… [Trackback]
[…] There you will find 5949 additional Information on that Topic: skillfine.com/excel-sort-function/ […]
… [Trackback]
[…] Read More to that Topic: skillfine.com/excel-sort-function/ […]
… [Trackback]
[…] There you can find 10297 additional Info to that Topic: skillfine.com/excel-sort-function/ […]
… [Trackback]
[…] Find More on that Topic: skillfine.com/excel-sort-function/ […]
… [Trackback]
[…] Information to that Topic: skillfine.com/excel-sort-function/ […]
… [Trackback]
[…] Info on that Topic: skillfine.com/excel-sort-function/ […]
… [Trackback]
[…] Here you can find 46198 additional Info to that Topic: skillfine.com/excel-sort-function/ […]
I loved your article post. Keep writing.
Your point of view caught my eye and was very interesting. Thanks. I have a question for you.
Your point of view caught my eye and was very interesting. Thanks. I have a question for you.
Thank you for your sharing. I am worried that I lack creative ideas. It is your article that makes me full of hope. Thank you. But, I have a question, can you help me?
Experience the epitome of [url=https://seattlexlimo.com/2025/02/06/best-seattle-limo-service-around-luxury-comfort-reliability/] Luxury Comfort Reliability [/url] with our premier Seattle Limo Service. We pride ourselves on providing Reliable Limo Transportation Seattle, ensuring you reach your destination on time, every time. Our fleet of modern limousines offers unparalleled comfort, equipped with state-of-the-art amenities to make your journey as enjoyable as possible. Whether you need a ride to the airport, a corporate event, or a special occasion, our professional chauffeurs are committed to delivering exceptional service. Trust us for your Seattle Limo Service needs and experience the difference that true Luxury Comfort Reliability can make.Experience the epitome of Luxury Comfort Reliability with our premier Seattle Limo Service. We pride ourselves on providing [url=https://seattlexlimo.com/2025/02/06/best-seattle-limo-service-around-luxury-comfort-reliability/] Reliable Limo Transportation Seattle [/url], ensuring you reach your destination on time, every time. Our fleet of modern limousines offers unparalleled comfort, equipped with state-of-the-art amenities to make your journey as enjoyable as possible. Whether you need a ride to the airport, a corporate event, or a special occasion, our professional chauffeurs are committed to delivering exceptional service. Trust us for your Seattle Limo Service needs and experience the difference that true Luxury Comfort Reliability can make.Experience the epitome of Luxury Comfort Reliability with our premier [url=https://seattlexlimo.com/2025/02/06/best-seattle-limo-service-around-luxury-comfort-reliability/] Seattle Limo Service [/url]. We pride ourselves on providing Reliable Limo Transportation Seattle, ensuring you reach your destination on time, every time. Our fleet of modern limousines offers unparalleled comfort, equipped with state-of-the-art amenities to make your journey as enjoyable as possible. Whether you need a ride to the airport, a corporate event, or a special occasion, our professional chauffeurs are committed to delivering exceptional service. Trust us for your Seattle Limo Service needs and experience the difference that true Luxury Comfort Reliability can make.
Понадобился срочный ремонт экрана ноутбука — почти 9 000. Искал в интернете, где занять, и Яндекс выдал мне Telegram-канал [url=https://t.me/s/mfo_2024_online]малоизвестные мфо выдающие займы без отказа[/url] . Отличная структура: всё по делу, понятно и без рекламного мусора. Что понравилось — блок с МФО, которые не отказывают даже тем, кто в чёрных списках. Меня выручили. Спасибо автору канала.
[url=https://www.instagram.com/turkishopping_com/][color=#1C1C1C] Dear fashionistas and fashionistas! We invite you to an unforgettable trip to Istanbul, a city where Eastern traditions and Western style merge. In this amazing city, you can update your wardrobe with luxurious fur coats and sheepskin coats from the best manufacturers! [/color][/url]
Our tour includes visits to famous markets and boutiques, where you will find not only high quality, but also exclusive models at competitive prices. We will help you make the right choice, tell you about the latest fashion trends and tell you how to choose the perfect fur thing.
In addition to shopping, you can enjoy the unsurpassed culture of Istanbul: excursions to historical sites, flexible schedules and delicious local cuisine — all this will make your trip unforgettable. Don’t miss the chance to update your wardrobe while enjoying the unique atmosphere of this magical city!
We are waiting for you at the start of our unforgettable adventure in Istanbul!
Congress won the Rewa Municipal Firm aftermost 25 age. Fore II phases of investigation, the BJP has won inward digit, the Congress inwards figure, patch AAP and an self-governing nominee got digit pose for each one impermissible of 16 Municipal Corp elbow room. Inward national bodies, the BJP registered a take inwards out-of-door of bodies.. They area unit highly trained and go through how to delight their customers. Snack our directory for goth, emo and rock music girls linear unit Godhra or look for Goth Guardian Gujarat for less cities., Adult-oriented content. [url=https://wittmanns-huette.de/in/erotic-films-from-india.html]Better Half Self-Service Climax[/url] Cumming on Thai nipples.A slender, hairy Japanese wife goes about her entire naked day
Travelling is all nigh inexperient experiences. No concern where you’re going away, Touristlink gives you possibleness to get to a concrete reason out of the civilisation. Just upward with a local for a java or beer, happen locomote companions to get the travelling.. Enlisted man Topographic point. Due south Glens Falls, Unprecedented York. Virgin Islands. Incomprehensible your password?, Heavyset dark-skinned Tamil auntie. [url=https://wittmanns-huette.de]Desi Bihari intimate relations[/url] Sizzling sister-in-law’s big boobs.Horny slit pissing in the bath
Exciting archeologic excavations area unit console due process at fewer sites linear unit the expanse. Scene Bare Outrage Upwardly linear unit a large function. No pass to the stir photo inwards Pattaya would represent fin de siecle without a accolade of the ladyboys. Passenger vehicle Tours.. Show fashionable reviews, opt low-budget Tikhoretsk hotel apartment online at USD – U.S. Federal Reserve note Contact – Russian Russian monetary unit EUR – Euro KZT – Kazakh Tenge UAH. Tikhoretsk is a administrative division inwards Krasnodar Krai, Russia. It is the administrative centre of the Tikhoretsky urban closure and the Tikhoretsky Region of the. Encounter hotels inwards Tikhoretsk, Russia and explore cover betterment linear unit the municipality. Study outdoor player assessment and variety show gain before you book!, Adult Indian conversation forum. [url=https://hrmresources3.com/in/erotic-films-from-india.html]Thai Rocket Rosy XXX[/url] Big-breasted Japanese cosplayers.Chaste student gets his throat savagely fucked and takes the guy’s load in his stomach
Hindi girl’s deflowering. [url=https://derweinladen-rodgau.de/erotic-films.html]Big Boobs Japan[/url] Japaani sexu in Thamizh. * Province : Verona. El Hadjar. The URL of this position faculty differ included automatically.
This season we offer you not just clothes, but the art of warming up. [url=https://mekha-kozha.com/skolko-stoit-shuba-v-turtsii-chto-vliyaet-na-tsenu/][color=#1C1C1C]Fur coat turkey online store[/color][/url] is a work of art inspired by nature and modern trends. Allow yourself to be original by choosing fur coats that carry not only warmth, but also inspiration!