FILTER Function Archives

FILTER Function

Excel VLOOKUP to Return Multiple Values in One Cell Separated by Comma

Oct 1, 2022 Excel Formulas

This article illustrates how to Vlookup and return multiple values in one cell in excel separated by a comma. Excel has several functions for Vlookup ...

How to Create a Schedule in Excel That Updates Automatically

Oct 3, 2022 Excel Formulas

Creating a schedule is a part and parcel of many of our lives. Creating the schedule automatically will be immensely helpful for many people. If you ...

How to Skip Lines in Excel (4 Suitable Ways)

Sep 25, 2022 Excel Formulas

Blank lines in a Microsoft Excel spreadsheet are rather common phenomena. Most of them are redundant, and they take up additional space on the ...

How to Create a Filtering Search Box for Your Excel Data (5 Ways)

Sep 1, 2022 Excel Formulas

When there is lots of data then if you have a Filtering Search Box for your Excel data then it will be very helpful for you to find any data within a ...

Excel Formula to Skip Rows Based on Value (7 Examples)

Sep 6, 2022 Excel Formulas

Sometimes, we need to skip rows based on the cell value. Using Excel formulas, we can easily do such jobs in a few seconds. In this article, we will ...

How to Filter Missing Data in Excel (4 Easy Methods)

Sep 1, 2022 Excel Formulas

Filtering for a value in a list, whether missing or not, is too common in Excel. But the excel filter command can't do it, we need to use formulas ...

Consolidate Function for Text Data in Excel (with 3 Examples)

Jul 4, 2022 Excel Formulas

While working on multiple worksheets, you may want to consolidate text data with the Excel function. So you can combine text data from multiple ...

How to Filter Dates by Month and Year in Excel (4 Easy Methods)

Jul 14, 2022 Excel Formulas

In this article, you will find some easy methods to filter dates by month and year in Excel. It is very common to filter dates by month or year as ...

How to Create a Task Tracker in Excel (Download Free Template)

Jul 26, 2022 Excel Basics 2

Although there is no direct tool to track tasks in Excel, we can use a combination of different functions and formulas to create a dynamic task ...

How to Create a Searchable Database in Excel (2 Quick Tricks)

Jun 1, 2022 Advanced Excel

While working with large Microsoft Excel, sometimes we need to search for some data. Creating a searchable database in Excel is an easy task. This is ...

How to Filter Multiple Values in One Cell in Excel (4 Methods)

Sep 11, 2022 Excel Basics

While working with large Microsoft Excel, sometimes we need to filter multiple values in one cell. Filtering data is more important in Excel. We can ...

Excel INDEX-MATCH Formula to Return Multiple Values Horizontally

Aug 25, 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)

Aug 24, 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 ...

How to Filter by List in Another Sheet in Excel (2 Methods)

May 30, 2022 Excel Basics

The FILTER function allows us to filter a set of data based on a set of criteria. Filtering data based on a list in another worksheet is also ...

How to Filter Column Based on Another Column in Excel (5 Methods)

May 30, 2022 Excel Basics

In this article, we’re going to show you 5 methods of how to use Excel to Filter a column based on another column. To demonstrate these methods, ...