SMALL Function Archives

SMALL Function

How to Vlookup and Return Multiple Values in Drop Down List

Sep 27, 2022 Excel Formulas

VLOOKUP is a useful function to look for the values in the dataset and return the necessary part of that dataset. If you are curious to know how you ...

How to Calculate Average Quarterly Revenue in Excel (8 Ways)

Sep 28, 2022 Excel Formulas

Calculating the average is a common task in our regular professional life. Almost every day, we calculate the average of something according to our ...

Excel VLOOKUP Function to Return Min Value from Multiple Hits

Sep 25, 2022 Excel Formulas

Looking for ways to know how to VLookup to return min value from multiple hits? We can VLookup to return the min value in Excel using different ...

How to Create a Filtering Search Box for Your Excel Data (5 Ways)

Sep 1, 2022 Excel Formulas

When there is lots of data then if you have a Filtering Search Box for your Excel data then it will be very helpful for you to find any data within a ...

Excel Chart: Ignore Blank Axis Labels (with Easy Steps)

Aug 10, 2022 Excel Charts

There are a few reasons for which you might want to ignore blank axis labels in an Excel Chart. Such as, it can make the chart look cleaner and less ...

How to Calculate Average Salary in Excel (6 Effective Methods)

Jul 17, 2022 Excel Formulas

A common task in business and in everyday life is calculating the average salary. Excel makes calculating the average salary easy. Excel has a ...

How to Drag Formula Horizontally with Vertical Reference in Excel

Jul 5, 2022 Excel Basics

Sometimes you might need to drag the formula horizontally with the vertical reference. In other words, you have to utilize the Fill Handle Tool for ...

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

Jun 12, 2022 Excel Formulas 2

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

Aug 25, 2022 Excel Formulas 5

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

How to Sort Data by Value in Excel (5 Easy Methods)

Aug 21, 2022 Excel Basics

In this article, I will discuss how you can sort data by value in Microsoft Excel. While working with a large amount of data in excel, often we need ...

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

May 31, 2022 Excel Formulas

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

Aug 25, 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 Sort Data in Alphabetical Order in Excel (8 Methods)

Aug 21, 2022 Excel Basics

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)

Aug 22, 2022 Excel Basics

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