FILTER Function

Excel INDEX-MATCH Formula to Return Multiple Values Horizontally

We can search match objects in Excel in different ways. There are different Excel functions, VBA codes are used to find the matching and return them. ...

How to Remove Blank Rows in Excel (7 Methods)

As an Excel user, it is very common to work with a large set of data. Excel gives a platform to set your data nicely but sometimes blank rows in ...

Create a Searchable Drop Down List in Excel (2 Methods)

This article illustrates how to create a searchable drop-down list in excel. It shows the 2 ways you can do that in excel using formulas and VBA. The ...

Count Unique Text Values with Criteria in Excel (5 Methods)

This article illustrates 5 methods on how to count unique text values with criteria in excel. You may need to extract customer names who appear ...

How to Create a Dynamic Top 10 List in Excel (8 Methods)

A top list is used to rank the companies or individuals based on values. This rank is set based on performance, quality, etc., or other criteria. In ...

How to Perform VLOOKUP with Multiple Rows in Excel (5 Methods)

While working with the Microsoft Excel dataset, sometimes we need to look up unique values from multiple rows. We can easily do that by applying the ...

How to Filter Unique Values in Excel (8 Easy Ways)

Filter Unique is an effective way to get around with numerous entries in a dataset. Excel offers multiple features to filter unique data or remove ...

How to Filter by Date in Excel (4 Quick Methods)

While working in Excel we frequently need to filter data by date for different purposes. There are a lot of ways to do it. This article will provide ...

How to Sort Unique List in Excel (10 Useful Methods)

When you have a larger dataset and you need to sort the dataset based on unique values, that is to say, you want to skip duplicate values. Getting ...

How to Filter Horizontal Data in Excel (3 Methods)

This article explains three methods to filter horizontal data in Excel. Filtering data vertically is easier with the default Filter feature, pivot ...

How to Lookup Multiple Values in Excel (10 Ways)

When conducting data analysis in Microsoft Excel, you may need to obtain all matching data for a certain id, username, contact information, or ...

Find Unique Values in a Column in Excel (6 Methods)

In Microsoft Excel, extracting unique values from a column is one of the crucial tasks. You will find yourself in various situations where you may ...

How to Find Multiple Values in Excel (8 Quick Methods)

In this article, I will discuss how to find multiple values in Excel. Often, while working with spreadsheets, finding multiple values at once can be ...

How to Delete Unused Rows in Excel (8 Easy Ways)

Often, while working in Excel, we encounter unused rows or blank rows in our dataset. In this article, we demonstrate how to delete unused rows in ...

Formula to Remove Blank Rows in Excel (5 Examples)

Having blank rows in a Microsoft Excel worksheet is a common scenario. Most of them are unnecessary and they consume more spaces that increase the ...

ExcelDemy
Logo