SMALL Function

How to Use Partial VLOOKUP in Excel (5 Suitable Examples)

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

VLOOKUP and Return All Matches in Excel (7 Ways)

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

How to Vlookup with Multiple Matches in Excel (with Easy Steps)

One of the most amazing and widely used functions of Excel is the VLOOKUP function. So far, we have learned to pull out a single match from a range ...

How to Find Minimum Value Based on Multiple Criteria in Excel

In this tutorial, I am going to show you 7 easy ways to find minimum value based on multiple criteria in Excel. MS Excel provides a simple function ...

VLOOKUP to Return Multiple Values Horizontally in Excel

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 (3 Easy Ways)

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)

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)

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)

The ROWS function is a popular Excel built-in function that can be categorized under the LOOKUP and REFERENCE Functions. This function returns the ...

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

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 with Excel Formula

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

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

How to Create Top 10 List with Duplicates in Excel (5 Ways)

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. Now, today we are going to show ...

How to Return Multiple Values Based on Single Criteria in Excel

If you are looking for Excel to return multiple values based on single criteria, then you are in the right place. While using Excel, finding multiple ...

How to Find Lowest Value with Criteria in Excel (7 Effective Ways)

Finding the lowest value may be an essential task in some cases. We can easily do those tasks with the help of Microsoft Excel. Have you tried this ...