Filter in Excel

Excel AutoFilter: A Complete Guide

In this article, you will learn about Excel AutoFilter. From enabling AutoFilter to applying different criteria, you will find them here. Filtering ...

How to Convert Text Filter to Date Filter in Excel (3 Examples)

Among many useful features of Excel in our everyday life, data filtering is one of them. We can insert data filters in Excel through tables, pivot ...

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 Date Range in Excel (5 Easy Methods)

This article will provide some valuable methods on how to filter a range of date(s) in Excel. Suppose you have sales information for one month, but ...

How to Add Filter in Excel (4 Simple Methods)

Adding filter in Excel is the process of applying a filter to a range of data to selectively display only the rows that meet certain criteria. It ...

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

Shortcut for Excel Filter (3 Quick Uses with Examples)

Application of the Excel filter shortcut in Microsoft Excel is a very convenient approach to use the filtering option. It not only saves our time but ...

How to Use Text Filter in Excel (5 Examples)

Filter in Excel is a great tool that you can use in a large worksheet to find out all the information that matches the criteria of the Filter very ...

How to Perform Custom Filter in Excel (5 Ways)

Excel sheets with massive datasets are hard to deal with. But if you can filter the dataset according to your specific need, then the task becomes ...

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 Remove Filter in Excel (5 Easy & Quick Ways)

In the Excel sheet, we do apply Filter to do an analysis of particular data. While showing the required data Filter hides other data. Anyone may need ...

How To Search Multiple Items in Excel Filter (2 Ways)

  We have a simple table having a few random Persons from different Countries and their respective Favorite Sports and Favorite Player. We ...

How to Apply Multiple Filters in Excel: 6 Methods

Before going to the steps, consider the following dataset. Here, the Names of 15 Sites are given along with their Category. Furthermore, the Visits ...

How to Filter with Multiple Criteria in Excel (4 Easy Ways)

Today I will be showing you how Excel filter multiple criteria of some matching data using the FILTER function of Excel. Before going to the main ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo