SMALL Function Archives

Stem and Leaf Plot in Excel: A Robust Tool to Visualize Data

May 23, 2023

Stem and leaf plots are useful tools for organizing and displaying numerical data. They provide a simple way to visually represent data without ...

Stem and Leaf Plot in Excel: A Robust Tool to Visualize Data

Excel MIN Function Returns 0: 2 Possible Scenarios

May 7, 2023

You may use Excel’s MIN function to get the minimum value from a range of cells. In some cases your Excel MIN function returns 0. In this article, ...

Excel MIN Function Returns 0: 2 Possible Scenarios

How to Use LARGE and SMALL Function in Excel (3 Examples)

Jan 25, 2023

If you want to find the 3rd most expensive smartphone from a list of smartphones, or you’re searching to solve a problem like this, you’re on the ...

How to Use LARGE and SMALL Function in Excel (3 Examples)

How to Lookup Next Largest Value in Excel (4 Easy Ways)

Jan 23, 2023

We may need to lookup the next largest value in excel, as we work on a dataset. Excel has functions that can help us to solve this problem. In this ...

How to Lookup Next Largest Value in Excel (4 Easy Ways)

How to Check If Cell Contains One of Several Values in Excel

Feb 13, 2023

Looking for ways to check if a cell contains one of several values in Excel? Then, this is the right place for you. Using different functions, you ...

How to Check If Cell Contains One of Several Values in Excel

How to Pull Data from a Date Range in Excel (7 Handy Ways)

May 17, 2023

Unquestionably, Microsoft Excel excels at crunching numbers! Now, this means that you can perform tedious calculations, like Filter Date Ranges, in ...

How to Pull Data from a Date Range in Excel (7 Handy Ways)

How to Sort Odd and Even Numbers in Excel (4 Easy Examples)

Jan 4, 2023

If you want to sort odd and even numbers in Excel, you have come to the right place. Here, we will walk you through 4 easy and effective examples to ...

How to Sort Odd and Even Numbers in Excel (4 Easy Examples)

Intersection of Two Columns in Excel (7 Easy Methods)

Feb 28, 2023

While working in Microsoft Excel sometimes we need to find intersection of two columns. But sometimes it becomes difficult if you are not aware of ...

Intersection of Two Columns in Excel (7 Easy Methods)

Return Non Blank Cells from a Range in Excel (3 Suitable Ways)

Feb 16, 2023

Microsoft Excel is, in fact, a beneficial program. We can do many things with a given dataset using Excel's tools and features. In Excel, we often ...

Return Non Blank Cells from a Range in Excel (3 Suitable Ways)

How to Separate Odd and Even Numbers in Excel (6 Handy Ways)

May 18, 2023

This article will show how to separate odd and even numbers in Excel. In addition to that, we will also see how to filter odd and even numbers and ...

How to Separate Odd and Even Numbers in Excel (6 Handy Ways)

Can Excel DGET Return Multiple Records [See 4 Solutions]

Mar 1, 2023

The DGET function in Excel is a database function and is designed to return only one record. In case you have multiple matches and need to return ...

Can Excel DGET Return Multiple Records [See 4 Solutions]

How to Create Table from Another Table in Excel (3 Easy Ways)

Dec 28, 2022

Sometimes when dealing with Excel tables, we need to create a new table depending on requirements from the existing data. In this article, I'll ...

How to Create Table from Another Table in Excel (3 Easy Ways)

How to Create Table from Another Table with Criteria in Excel

Feb 7, 2023

When working with Excel tables, sometimes we need to create another table from the existing tables based on criteria. In this article, I will show ...

How to Create Table from Another Table with Criteria in Excel

How to Create Array Formula in Excel (13 Suitable Examples)

Apr 10, 2023

Creation and usage of the Array formula is an essential part of Excel operations. The use of Multiple and Single-cell Array formulas is essential for ...

How to Create Array Formula in Excel (13 Suitable Examples)

How to Concatenate with VLOOKUP in Excel (4 Easy ways)

Feb 26, 2023

While working in Microsoft Excel, there are various formulas to make our work easier. The VLOOKUP formula is one of them. It has a wide range of ...