SMALL Function

### How to Calculate Range in Excel (5 Handy Methods)

Range in statistics is the difference between the highest value and lowest value of a set of data. We need to apply range in the real work fields a ...

### How to Make an Eisenhower Matrix Template in Excel (With Easy Steps)

This tutorial will be a step-by-step guideline to make an Eisenhower Matrix template in Excel. The Eisenhower Matrix is very useful to fix the ...

### Excel INDEX MATCH to Return Multiple Values in One Cell

The most often used functions in Microsoft Excel for executing more sophisticated lookups are INDEX and MATCH. This is because INDEX and MATCH are so ...

### How to Create a Ranking Graph in Excel (5 Methods)

This article illustrates how to create a ranking graph in excel. A ranking graph can be very helpful to keep track of the performances of your ...

### Excel INDEX-MATCH Formula to Return Multiple Values Horizontally

We can search match objects in Excel in different ways. There are different Excel functions, VBA codes are used to find the matching and return them. ...

### How to Extract Data from a List Using Excel Formula (5 Methods)

In Microsoft Excel sometimes we may need to extract data from a range or list. This process can be done in various ways. Today in this article, I am ...

### How to Find Lowest Value in an Excel Column (6 Ways)

Finding the lowest value from a group of data is a very important and recurring task in Data Analysis processes. Even for the simplest arrays, it can ...

### How to Return Row Number of a Cell Match in Excel (7 Methods)

In this tutorial, we will demonstrate how to return the row number of a cell match in excel. If we say it more clearly, we will select a value from a ...

### Create Excel Filter Using Drop-Down List Based on Cell Value

A drop-down list filter is basically a list of unique names. If you select any of the items from the drop-down list, you will get the corresponding ...

### 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 ...

### INDEX-MATCH with Multiple Criteria for Partial Text in Excel (2 Ways)

In this article, we will learn to use the INDEX-MATCH Formula with multiple criteria for partial text. We use INDEX and MATCH Functions to look up ...

### How to Remove Used Items from Drop Down List in Excel (2 Methods)

While working with data validation in Excel, you might need to remove used items from the drop-down list to avoid assigning an item in the list ...

### Creating a Drop Down Filter to Extract Data Based on Selection in Excel

The Filter feature in Excel helps us to extract data according to our selections. But the problem with the feature is that the row numbers and the ...

### How to Remove Blanks from Data Validation List in Excel (5 Methods)

This article will briefly describe some valuable methods on how to remove blanks from a data validation list in Excel. When we have blanks in a list ...

### How to Remove Blank Cells Using Formula in Excel (7 Methods)

Our dataset often has blank cells. We can remove blank cells in Excel by using more than one formula. We have a dataset of the employees of a ... Advanced Excel Exercises with Solutions PDF  