SORT Function

### How to Correct a Spill (#SPILL!) Error in Excel (7 Easy Fixes)

The #SPILL error is a widespread Excel problem that affects most individuals who utilize Office 365 Excel versions. The newest release of Excel under ...

### How to Sort Rows by Date in Excel (8 Methods)

It’s common to have data with dates and users usually sort rows in Excel by date. Various Excel features such as Sort & Filter. Filter, Custom ...

### How to Auto Sort in Excel without Macros (3 Methods)

This article illustrates 3 methods to auto sort data in excel without macros. We’ll use the SORT, VLOOPUP, INDEX, and MATCH functions to sort a ...

### How to Sort Data in Alphabetical Order in Excel (8 Methods)

Quite often, we have to perform the Sort operation on our Excel data. Additionally, we can sort the data based on numerous orders. The Alphabetical ...

### How to Put Numbers in Numerical Order in Excel (6 Methods)

In this article, we’re going to show you 6 methods of how to put numbers in numerical order in Excel. To demonstrate our methods, we’ve taken a ...

### Excel Data Validation Drop Down List with Filter (2 Examples)

In this article, I will discuss how you can filter excel data using a Data Validation drop-down list. Usually, in Microsoft Excel, we use the Filter ...

### How to Copy Filter Drop-Down List in Excel (5 Ways)

If you are trying to copy the filter drop-down list in Excel effectively, then this article is for you. Here, we will discuss different 5 ways for ...

### How to Remove Duplicates from Drop Down List in Excel (4 Methods)

While working with a large Microsoft Excel dataset, sometimes we need to create a drop-down list and remove the duplicates from the drop-down list. ...

### How to Use IF Formula for Date Range in Excel (6 Methods)

You can use the IF function to create an IF formula for working with the date range in Excel. In this article, we’re going to show you how to use  IF ...

### How to Create a Drop Down List with Unique Values in Excel (4 Methods)

While working with categorical information in Excel i.e., products of different categories, you might need to create a drop-down list with unique ...

### How to Create a Dynamic Top 10 List in Excel (8 Methods)

A top list is used to rank the companies or individuals based on values. This rank is set based on performance, quality, etc., or other criteria. In ...

### How to Sort Drop Down List in Excel (5 Easy Methods)

In this tutorial, I will show some methods to sort a drop-down list in excel. Often, when we work with lots of data or repetitive data, if we can ...

### How to Auto Sort Table in Excel (5 Methods)

While working with a large data table in Microsoft Excel, sometimes we need to sort tables and Excel can easily do it. Excel is very useful for ...

### How to Add Sort Button in Excel (7 Methods)

Sort button in Excel is a very powerful and useful feature that will let you sort the information in a large Excel worksheet without any hassle. Sort ...

### How to Sort Unique List in Excel (10 Useful Methods)

When you have a larger dataset and you need to sort the dataset based on unique values, that is to say, you want to skip duplicate values. Getting ...

5 Excel Hacks You Never Knew