FILTER Function

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

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 Organize Raw Data in Excel (6 Easy Methods)

This article shows you how to organize raw data in Excel. Microsoft Office Excel comes with a number of features that make data management and ...

How to Filter Last 30 Days of Date in Excel (5 Easy Ways)

Typical Excel worksheets contain hundreds of rows with dates, amounts, etc. as entries. As a result, finding entries within a specific time period ...

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

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)

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)

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)

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

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

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

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)

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

How to Extract Data from a List Using Excel Formula (5 Methods)

In Microsoft Excel sometimes we may need to extract data from a range or list. This process can be done in various ways. Today in this article, I am ...

How to Use Pivot Table to Calculate Running Total by Date in Excel

The article will show some ways to calculate running total by date in Excel using the Pivot Table. Suppose you have data where you have sales on ...

How to Link Cells for Sorting in Excel (5 Methods)

Sometimes we have to link cells in Excel for sorting or various purposes. Typical linking of a cell requires inserting an Equal Sign (=) before a ...

How to Keep a Running Balance in Excel (8 Methods)

Keeping track of our expenses and deposit or remaining balance is a very important task in our daily life. Because that’s how we know how much we ...

ExcelDemy
Logo