SMALL Function Archives

How to Create a Risk Heat Map in Excel (3 Easy Methods)

May 14, 2022 Excel Basics

A heat map is a visual representation of the comparison of a dataset based on color. If you are looking for some special tricks to create a risk heat ...

Excel INDEX-MATCH Formula to Return Multiple Values Horizontally

Apr 20, 2022 Excel Formulas

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 Find Lowest Value in an Excel Column (6 Ways)

Apr 27, 2022 Excel Formulas

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

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

Apr 9, 2022 Advanced Excel

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

How to Exclude a Cell in Excel AVERAGE Formula (4 Methods)

May 24, 2022 Excel Basics

In Microsoft Excel, we use the AVERAGE formula to determine the average of specific values from a data range. To extract the exact value of the ...

How to Find Second Match with VLOOKUP in Excel (2 Simple Methods)

May 24, 2022 Excel Formulas

Finding specific cell values manually from a range in Excel datasheets is a really inconvenient process. This article will show you the simple ...

Excel Sort and Ignore Blanks (4 Ways)

May 23, 2022 Excel Basics

By default, when we sort data in Excel, it leaves all the blank rows at the end. But we don’t always want this. Sometimes we need to ignore the ...

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

May 23, 2022 Excel Basics

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 Sort Numbers in Excel (8 Quick Ways)

May 23, 2022 Excel Basics

To do analysis or to keep numbers in order, Sorting is important. In Excel, there are a couple of ways to Sort numbers. There are two possible ways ...

How to Create Drop Down List with Filter in Excel (7 Methods)

May 22, 2022 Advanced Excel

In Microsoft Excel, data entry becomes faster when we use a drop-down list filter. Filters may be used to filter down and conceal sections of our ...

44 Mathematical Functions in Excel (Download Free PDF)

May 22, 2022 Excel Basics

Microsoft Excel has plenty of mathematical functions that help perform various mathematical operations. In this article, you will get to know 44 ...

How to Lookup Multiple Values in Excel (10 Ways)

May 22, 2022 Excel Formulas

When conducting data analysis in Microsoft Excel, you may need to obtain all matching data for a certain id, username, contact information, or ...

How to Find Multiple Values in Excel (8 Quick Methods)

May 22, 2022 Excel Formulas

In this article, I will discuss how to find multiple values in Excel. Often, while working with spreadsheets, finding multiple values at once can be ...

Advanced Filter with Criteria Range in Excel (18 Applications)

May 19, 2022 Advanced Excel

In Microsoft Excel, the Advanced Filter option is helpful when looking for data that meets two or more criteria. In this article, we will discuss ...

Formula to Remove Blank Rows in Excel (5 Examples)

May 9, 2022 Excel Basics

Having blank rows in a Microsoft Excel worksheet is a common scenario. Most of them are unnecessary and they consume more spaces that increase the ...