FILTER Function Archives

Excel INDEX-MATCH Formula to Return Multiple Values Horizontally

Apr 20, 2022 Excel Formulas

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)

Apr 13, 2022 Excel Basics

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)

Apr 9, 2022 Advanced Excel

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)

Apr 9, 2022 Excel Formulas

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)

May 22, 2022 Advanced Excel

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)

May 23, 2022 Excel Functions

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)

May 23, 2022 Advanced Excel

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)

May 23, 2022 Advanced Excel

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)

May 23, 2022 Excel Basics

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)

May 23, 2022 Advanced Excel

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)

May 22, 2022 Excel Formulas

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)

Feb 26, 2022 Excel Basics

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)

May 22, 2022 Excel Formulas

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)

May 19, 2022 Excel Basics

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)

May 9, 2022 Excel Basics

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