FILTER 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 TEXTJOIN Function in Excel (3 Examples)

TEXTJOIN is one of the most important and widely used functions in Excel that has been available from Excel 2019. Today I will be showing how you ...

Conditional Drop Down List in Excel (Create, Sort and Use)

In Microsoft Excel, the applications of the conditional or dependent drop-down list are immense in the field of data analysis. And creating this ...

How to Create Dynamic Dependent Drop Down List in Excel

Today I will be showing how you can create a dynamic dependent drop down list in Excel using both Formulas and Tables. What is a Dynamic ...

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

Lookup Partial Text Match in Excel (5 Methods)

In Microsoft Excel, there are several useful methods to lookup partial text matches and then extract data based on that specific match. In this ...

Excel Auto Sort When Data Changes (9 Examples)

In Microsoft Excel, there are numerous procedures to auto-sort a table or an array if someone changes data. In this article, you'll learn how you can ...

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

How to Use Excel IF Function with Range of Values

IF is one of the most useful and widely used functions of Excel. Today I will be showing how to use this IF function with a wide range of values, ...

How to Sort Two Columns in Excel to Match (Both Exact and Partial Match)

While working in Excel, we often have to work with columns that are almost the same, and sometimes exactly the same. Today I will be showing how you ...

How to Lookup with Multiple Criteria in Excel (Both AND or OR Type)

While working in Excel, we are to do this often. We are to look up a particular value in a data set that satisfies one or more criteria. Today I will ...

How to Filter Cells with Formulas in Excel (2 Ways)

In Microsoft Excel, there are not too many ways to filter cells that contain formulas. From the 2013 version of Excel, it has initiated a logical ...

How to Use ISBLANK Function in Excel (2 Examples)

Today I will be showing how you can check whether a cell is empty or not using the ISBLANK function of Excel. Excel ISBLANK Function (Quick View) ...

ExcelDemy
Logo