SMALL Function

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

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)

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)

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)

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

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)

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

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)

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  Lookup or Reference Function. This function returns the number ...

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 in Excel using 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 ...

Excel Top 10 List with Duplicates

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

ExcelDemy
Logo