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

Sep 26, 2021 Excel Functions

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)

Nov 22, 2021 Excel Basics

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

Nov 22, 2021 Excel Formulas

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)

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

Lookup Partial Text Match in Excel (5 Methods)

Nov 17, 2021 Excel Formulas

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)

Oct 28, 2021 Excel Basics

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)

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

How to Use Excel IF Function with Range of Values

Oct 10, 2021 Excel Formulas

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)

Nov 1, 2021 Excel Formulas

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)

Oct 27, 2021 Excel Formulas 1

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)

Oct 31, 2021 Excel Formulas

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)

Nov 11, 2021 Excel Formulas

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