SMALL Function Archives

Create a Unique List in Excel Based on Criteria (9 Methods)

Sep 26, 2021 Advanced Excel

In Microsoft Excel, several methods are available to create a unique list under multiple criteria. The unique list is generally prepared to remove ...

How to Populate a List Based on Cell Value in Excel (6 Ways)

Nov 17, 2021 Advanced Excel

In MS Excel, sometimes we may need to determine or find values based on some criteria or condition from a list. Assuming we have a task plan with the ...

How to Use Partial VLOOKUP in Excel(3 or More Ways)

Nov 25, 2021 Excel Formulas

There may arise a situation where you need to perform a partial matching within VLOOKUP. To assist you, today we are going to show you how to operate ...

VLOOKUP and Return All Matches in Excel (7 Ways)

Nov 4, 2021 Excel Formulas

There are several ways to apply VLOOKUP or vertical lookup in Microsoft Excel to return data based on multiple matches. In this article, you’ll get ...

VLOOKUP with Multiple Matches in Excel

Nov 8, 2021 Excel Formulas

Today I will be showing how to use VLOOKUP to extract multiple matches in Excel. One of the most amazing and widely used functions of Excel is ...

Minimum Value Based on Multiple Criteria in Excel (7 Ways)

Sep 23, 2021 Excel Formulas

MS Excel provides a simple function called MIN which returns a minimum value from any range. But there might be a case where we need to find or ...

VLOOKUP to Return Multiple Values Horizontally in Excel

Nov 10, 2021 Excel Formulas 2

In Microsoft Excel, there are a few options to VLOOKUP and return multiple values horizontally. Although the VLOOKUP function itself is not able to ...

How to Sort Rows in Excel (2 Simple Methods)

Nov 8, 2021 Excel Basics

Sorting is one of the most common tasks in Excel, every now and then one may need to sort data. Most of our daily activities require column sorting, ...

Find Matches or Duplicate Values in Excel (8 Ways)

Oct 26, 2021 Excel Basics

In Microsoft Excel, there are several suitable methods to find matches or duplicate values with formulas or VBA. You can extract data based on the ...

How to Use SMALL Function in Excel (4 Common Examples)

Nov 11, 2021 Excel Functions

In Microsoft Excel, the SMALL function is generally used to extract the nth lowest or smallest value from a range of cells containing numerical data ...

How to Use ROWS Function in Excel (With 7 Easy Examples)

Nov 16, 2021 Excel Formulas

The ROWS function is a popular Excel built-in function that can be categorized under Lookup or Reference Function. This function returns the number ...

Advanced Filter with Multiple Criteria in Excel (15 Suitable Examples)

Nov 4, 2021 Data Analysis with Excel

In Microsoft Excel, using Advanced Filter with multiple criteria allows us to add different logics and functions to execute a wide range of ...

How to Arrange Numbers in Ascending Order in Excel using Formula

Nov 2, 2021 Excel Formulas

Depending on different circumstances you may need to arrange numbers, among other things, in a certain order. You can quite easily do the task using ...

How to Filter Data in Excel using Formula

Nov 1, 2021 Excel Formulas

To filter data in Excel is quite usual, often you need to filter data to find the sets of data you require to operate a particular operation. Today ...

Excel Top 10 List with Duplicates

Oct 26, 2021 Excel Formulas

For different purposes, you may need to find the top n number of values in Excel, n can be 5 or 10 and many more. Today we are going to show you how ...